|
|
Posted by Trevor Best on 05/21/07 10:25
I have a client with 150MB database, the transaction log file is
nearly 23GB. It's a PITA for me to backup his data and restore it on
my server as it takes about 30 minutes to restore as it re-creates a
23GB file with no transactions in it :-\
As well as the space taken up by it, does it do any harm being that
size? e.g. does it decrease performance?
While it's there, considering the database is backed up daily, does it
actually do any good?
I know how to truncate and shrink logs, is it advisable / safe /
worthwhile to do this on a regular basis?
Navigation:
[Reply to this message]
|