Restore to a database once it is brought online?

Compresses, encrypts, secures and monitors SQL Server backups.

Moderators: JonathanWatts, Chris Auckland, eddie davis, Colin Millerchip, Brian Harris, james.billings, RBA, petey

Restore to a database once it is brought online?

Postby SQL_ME_RICH » Fri Jul 06, 2012 12:46 am

Hello -

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?

Thank you,

SQL_ME_RICH
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby petey » Fri Jul 06, 2012 1:15 am

once it is online - that's it?

This.
Peter Yeoh
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 7
petey
 
Posts: 2233
Joined: Sun Apr 24, 2005 12:34 pm

Postby SQL_ME_RICH » Fri Jul 06, 2012 1:22 am

Thx.
SQL_ME_RICH
 
Posts: 64
Joined: Tue May 08, 2012 10:41 pm

Postby ChrisAVWood » Fri Jul 06, 2012 3:26 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.

HTH

Chris
English DBA living in CANADA
ChrisAVWood
 
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