Compresses, encrypts, secures and monitors SQL Server backups.
Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey
Say I have a Full backup of a database. I restore the Full backup, and have a series of Differential backups done against it since the Full. Now - the Full was restored to a different server and instance on another machine, and did not have the standby or offline options specified when it was restored (it was just brought up online like you would if you wanted to just get it in place and go). No changes were made to it from the restore - it's just there for review.
Is there any way to restore the additional Differential backups to that database that were taken from it after the Full? Or is it that once it is online - that's it?
- Posts: 64
- Joined: Tue May 08, 2012 10:41 pm
once it is online - that's it?
SQL Backup Consultant Developer
Associate, Yohz Software
- SQL Backup goodies under the hood, updated for version 7
- Posts: 2233
- Joined: Sun Apr 24, 2005 12:34 pm
We do this all the time. To save processing time, resources and space for certain largish databases they create the full and then a series of differentials. We then get requested to take these backups and copy to another server and then overwrite an original DB with the full and a certain differential. You just have to remember that the full has a with NORECOVERY and the differential has with RECOVERY.
English DBA living in CANADA
- Posts: 308
- Joined: Tue Dec 18, 2007 6:18 pm
- Location: Edmonton, Alberta, CANADA
Return to SQL Backup 7
Who is online
Users browsing this forum: No registered users and 1 guest