July 17, 2008 at 9:28 am
I created a new SQL 2005 db in production, and every day in the morning the data from Excel files gets uploaded into the SQL tables of the database, So that's the reason I made the recovery model of the database as "Simple".
Now I scheduled the FULL and Diff database backup's to run.
Full db backup runs every SUnday @10PM.
Diff DB backup runs Monday - Saturday @10PM.
The backup's have already started running since Sunday.
If the database crashes now, to restore the database can I do the follow:
1. Restore the Full DB backup from Sunday.
2. Restore the last Diff database backup only from last night 10PM.
Will this take care of restoring the database OR do I also need to apply all the Diff db backup's from Monday thru Yesterday. Thanks!!
July 17, 2008 at 10:59 am
You don't need to restore all the differential backups, just the last one before the time of the crash, because each one contains all the changes since the last full backup. That's why diff backups get progressively larger.
Greg
July 17, 2008 at 11:52 pm
🙂
DIFFERENTIAL BACKUP: it is the backup of databse since last full backup.
so if u r having many differnetial backups u have to go for the only latest differential backup .
thanks,
syed:P
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply