Red Gate forums :: View topic - Restore to a database once it is brought online?
Return to www.red-gate.com RSS Feed Available

Search  | Usergroups |  Profile |  Messages |  Log in  Register 
Go to product documentation
SQL Backup 7
SQL Backup 7 forum

Restore to a database once it is brought online?

Search in SQL Backup 7 forum
Post new topic   Reply to topic
Jump to:  
Author Message
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Fri Jul 06, 2012 12:46 am    Post subject: Restore to a database once it is brought online? Reply with quote

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
Back to top
View user's profile Send private message
petey



Joined: 24 Apr 2005
Posts: 2277

PostPosted: Fri Jul 06, 2012 1:15 am    Post subject: Reply with quote

Quote:
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
Back to top
View user's profile Send private message Send e-mail
SQL_ME_RICH



Joined: 08 May 2012
Posts: 60

PostPosted: Fri Jul 06, 2012 1:22 am    Post subject: Reply with quote

Thx.
Back to top
View user's profile Send private message
ChrisAVWood



Joined: 18 Dec 2007
Posts: 308
Location: Edmonton, Alberta, CANADA

PostPosted: Fri Jul 06, 2012 3:26 pm    Post subject: Reply with quote

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
Back to top
View user's profile Send private message
Display posts from previous:   
Reply to topic All times are GMT + 1 Hour
Page 1 of 1

 
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group