December 10, 2012 at 7:37 am
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.
December 10, 2012 at 7:55 am
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) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
December 10, 2012 at 8:01 am
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
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply