Restore Append instead of Restore Replace?

Compresses, encrypts, secures and monitors SQL Server backups.

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

Restore Append instead of Restore Replace?

Postby noob2013 » Fri Apr 19, 2013 2:42 pm

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?
noob2013
 
Posts: 19
Joined: Wed Jan 30, 2013 3:11 pm

Postby RajK » Sun Apr 21, 2013 11:49 am

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.
RajK
 
Posts: 58
Joined: Thu Feb 02, 2012 8:21 am


Return to SQL Backup 7

Who is online

Users browsing this forum: No registered users and 0 guests