hi all
i want to restore the database without overwrite the existing data in destination database.
is it possible.
help m
Technology Tips and News
hi all
i want to restore the database without overwrite the existing data in destination database.
is it possible.
help m
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