Red Gate forums :: View topic - Restore Append instead of Restore Replace?
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 Append instead of Restore Replace?

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



Joined: 30 Jan 2013
Posts: 19

PostPosted: Fri Apr 19, 2013 2:42 pm    Post subject: Restore Append instead of Restore Replace? Reply with quote

Using SQLBackup 7.3.1.1
I'm trying to restore some archived data (2012) to the current production database. Running through the GUI and it seems like the only options are Overwrite Existing Database or Create New Database

Is there a capability within SQLBackup to restore append to the current prod db like in Oracle's imp/exp utility?
Back to top
View user's profile Send private message
RajK



Joined: 02 Feb 2012
Posts: 58

PostPosted: Sun Apr 21, 2013 11:49 am    Post subject: Reply with quote

Once a SQL Server database is online then there is no option to append additional data changes from a backup to that 'online' database.

Having said that there is one way you could try to apply more changes to that database. To do this you will have to take this database offline by changing its state to 'norecovery' (using restore database with 'norecovery' option). After this you can apply further backups to this same database. Now the backups that 'could' be applied will need to have the correct LSN sequence (so if the next backup was was a FULL then that will need to be applied, if it was a DIFF then that will need to be applied etc).

I hope this helps in your situation.
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