Truncate database after backup - 06-10-2010 , 10:59 AM
With SQL 2000 our backup provider (EMC Legato) told each database to truncate
the logs after a successfull backup. SQL 2008 doesn't seem to have these
features, what is the best way to keep logs truncated (automated) yet keep
them available in case they are needed for a restore?
Re: Truncate database after backup - 06-10-2010 , 03:23 PM
sgrigg (sgrigg (AT) discussions (DOT) microsoft.com) writes:
I'm not really sure what you mean with "truncate" but if you mean
TRUNCATE_ONLY or NO_LOG, that was a bad idea, since you lost the
ability to restore to a point-in-time. You can still truncate the
log in that way if you want to: just switch to simple recovery.
Erland Sommarskog, SQL Server MVP, esquel (AT) sommarskog (DOT) se
Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinf...ons/books.mspx