Re: Restore Transaction log or the .bak
From: Geoff N. Hiten (SRDBA_at_Careerbuilder.com)
Date: 05/19/04
- Next message: Geoff N. Hiten: "Re: Scripting Database Maintenance Plans"
- Previous message: Joel: "Re: Can't make SQL use more than 80,000k for queries, tried everything..on sys w/ 1 gig of ram"
- In reply to: mmc: "Restore Transaction log or the .bak"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 19 May 2004 14:47:13 -0400
You need to read the BOL (Books On-Line) section on Backing up and Restoring
Databases located under Administering SQL Server. It is a bit long and
complex, but then the topic is somewhat complex and deserves a long
explanation.
-- Geoff N. Hiten Microsoft SQL Server MVP Senior Database Administrator Careerbuilder.com I support the Professional Association for SQL Server www.sqlpass.org "mmc" <anonymous@discussions.microsoft.com> wrote in message news:AD0940C9-56AF-4851-88B0-CBC2AB05058E@microsoft.com... > If there is inconsistency on the DB and I want to restore to a last known good state, should I restore the transaction log files which is backed up every hour or the .bak file which is backed up every night. Basically, what is the difference between the two? When should I use the Transaction log files? Thanks.
- Next message: Geoff N. Hiten: "Re: Scripting Database Maintenance Plans"
- Previous message: Joel: "Re: Can't make SQL use more than 80,000k for queries, tried everything..on sys w/ 1 gig of ram"
- In reply to: mmc: "Restore Transaction log or the .bak"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
