Which backup will work why?

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 - General » Which backup will work why?

Which backup will work why?

Rate Topic

Display Mode

Topic Options

Author

Message

New persopn

Posted Monday, December 10, 2012 7:37 AM

Valued Member

Group: General Forum Members
Last Login: Tuesday, May 14, 2013 12:56 AM
Points: 56, Visits: 163

Here i have one doubt.

1) here we are scheduled the backups full, differential,transactional log with same time and date.

here which backup will work first and also i want the reason.

Post #1394622

sgmunson

Posted Monday, December 10, 2012 7:55 AM

UDP Broadcaster

Group: General Forum Members
Last Login: Wednesday, May 15, 2013 8:20 AM
Points: 1,446, Visits: 1,883

This sounds like they've scheduled FULL backups of the database file, with DIFFERENTIAL backups of the transaction log file, but it's also clear that the statement was made by someone for whom English is not their primary language, as all the adjectives follow their associated nouns. Similary, what; exactly; do you mean by "work first" ? If I assume you're talking about which one will run first, you'll have to look at the actual schedule, which may be the SQL Agent, or might be a 3rd party scheduling tool. If I assume they both run at the same time, then which one finishes first will probably depend on data volume, but I don't even know if you can run both of those at the same time (lack on knowledge on my part as opposed to questioning whether or not they can).

Steve
(aka sgmunson)
Smile

Weight Loss Tips

Post #1394636

anthony.green

Posted Monday, December 10, 2012 8:01 AM

SSCertifiable

Group: General Forum Members
Last Login: Friday, April 12, 2013 3:51 AM
Points: 5,075, Visits: 4,831

A FULL backup will reset the differential base LSN, so any DIFF's which dont follow on from the FULL's LSN will not be able to be applied.

Check msdb.dbo.backupset for the LSN chain and you will be able to see if the DIFF can be restored to the FULL.

As for a LOG backup, they can be taken at the same point as a FULL or DIFF, and the only thing that resets the LOG's base LSN is a change in the recovery model to SIMPLE and back again to FULL or BULK-LOGGED

Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1394638

« Prev Topic | Next Topic »

Permissions