Truncate database after backup

#1

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?

#2

sgrigg (sgrigg (AT) discussions (DOT) microsoft.com) writes:

Quote:

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?

You should backup your transaction logs regularly.

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

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Truncate database after backup

microsoft.public.sqlserver.tools microsoft.public.sqlserver.tools

Truncate database after backup - 06-10-2010 , 11:59 AM

Re: Truncate database after backup - 06-10-2010 , 04:23 PM