question

sand143eep avatar image
sand143eep asked

restoration of backup in sql 2005

Actually we have two environments with sql server 2005 database one is new environment and the other is older one. now there are updates happened in newer environment database, now client is asking to restore the older database in to the newer environment again and he wants the updates to remain same in the newer environment which are newely updated. i am confused is there any process that i can restore the database with having the changes as it is in newer environment.
sql-server-2005restorebackups
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

1 Answer

· Write an Answer
Grant Fritchey avatar image
Grant Fritchey answered
When you run a backup, you get a page by page copy of the database. When you run a restore, it uses that same page by page copy to create a new database or overwrite an existing one. If you have made changes to a database (data or structure) and you want to keep them in place, then you simply cannot run a restore. A few options to think about. Do you have the scripts you used to make the changes? You could restore the database and then reapply those scripts. Do you have access to Red Gate SQL Compare & Data Compare (or a similar product)? You can restore the old database to a different location and then migrate the new stuff over. Or vice-versa, make a copy of the new database, restore the old one on top & then move the new stuff over. Although, you keep saying environment. If you have only made changes to the server, then restoring a database is not going to undo those changes (unless we're talking the master database which is a different issue entirely).
10 |1200 characters needed characters left characters exceeded

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.