Re: backup advise
- From: Erland Sommarskog <esquel@xxxxxxxxxxxxx>
- Date: Mon, 31 Dec 2007 09:19:23 +0000 (UTC)
David Greenberg (davidgr@xxxxxxxxxx) 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@xxxxxxxxxxxxx
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
.
- References:
- backup advise
- From: David Greenberg
- backup advise
- Prev by Date: backup advise
- Next by Date: database optimization
- Previous by thread: backup advise
- Next by thread: database optimization
- Index(es):
Relevant Pages
|
