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