x

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.

more ▼

asked May 14, 2013 at 12:45 PM in Default

avatar image

sand143eep
921 40 50 56

(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

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).

more ▼

answered May 14, 2013 at 01:01 PM

avatar image

Grant Fritchey ♦♦
137k 20 44 81

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.

Topics:

x2029
x129
x31

asked: May 14, 2013 at 12:45 PM

Seen: 736 times

Last Updated: May 14, 2013 at 02:56 PM

Copyright 2017 Redgate Software. Privacy Policy