|
|
Posted by Erland Sommarskog on 12/31/07 09:19
David Greenberg (davidgr@iba.org.il) writes:
> We usae Sql2000.
> I'm setting up backups jobs and need advise.
> When I run a backup of a database, does it automatically clean out the
> transaction log ? For a complete backup ? for a differential backup ?
No. Backing up the database and backing up the transaction log are two
separate operations.
Before you go ahead, determine what level of recovery you need. If the
database goes belly-up, do you need restore to a point in time? Or would
you be content with restoring the most recent backup?
In the former case, you need to use full recovery and you need to back up
your transaction log regularly. In the latter case, you can go with simple
recovery and forget all about the transaction log. SQL Server will
automatically truncate the transaction log regularly so that only active
transctions remain.
> When would it be best to run a shrinkdatabase command ? Why would I want
> to run the shrinkdatabase ?
Most of the time you don't want to. Shrinking the database is a very
exceptional operation. This article gives some insight about this:
http://www.karaszi.com/SQLServer/info_dont_shrink.asp
--
Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx
Navigation:
[Reply to this message]
|