Restore database without overwrite the existing data

hi all

  i want to restore the database without overwrite the existing data in destination database.

 is it possible.

help  m

August 6th, 2013 2:42am

Hi Selvakumar

In Sql Server the backup are in point in time, if any of those when you restore, they will the restore all the data changes from backup file.

In sql server we have two kind of backup strategy - > Full and Differential (There is no incremental backup).

Please read this blog => http://sqlmag.com/blog/does-sql-server-have-incremental-data-backups.

You can always use the differential backup and restore  but in will not guarantee that it will not overwrite the data.

To Read more use this link => http://technet.microsoft.com/en-us/library/ms175510.aspx

 

August 6th, 2013 2:56am

No, You cannot. What you can do is restore the database with a new name and then later merge the data you need.
Free Windows Admin Tool Kit Click here and download it now
August 6th, 2013 3:07am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics