quote:
After every full backup I automatically run these 2 commands to reclaim the space the TLog has allocated:backup log DBName with truncate_only
DBCC SHRINKDATABASE (N'DBNAME', 0,TRUNCATEONLY
Have you ever tried a test restore?
If you truncate the log without backing it up (as with your statement), you have broken the chain of tran logs and any subsequent tran log backup is worthless. I suggest instead backing up the tran log before your full backup. That will truncate the log and make one fewer log file to apply when recovering from the backup.
If you let your database and log files autogrow only to constantly reshrink them, you're harming performance in two ways:
--Jonathan
Edited by - Jonathan on 11/26/2003 08:02:31 AM
--Jonathan