August 5, 2008 at 6:36 am
I want to backup my production database and restore is on the test server. The database names are the same on both servers, however, the test server has additional tables, sprocs, and views that I don't want overwritten. Can someone please help me with this? I am totally new as an administrator. Thanks.
August 5, 2008 at 7:00 am
Restore your database to your test server, but give it another name so it does not over-write what you have, make sure you change the .LDF + .MDF file paths so you don't over-write your old ones.
Then copy the objects you want from the Restored Version into your test database..
August 5, 2008 at 10:09 pm
or
1) script out/SSIS those objects you want to keep from the test database,
2) restore the production database to the test database,
3) copy back the saved objects to the test database.
It works better if the production database size is much bigger than the size of those objects you want to keep.
You can automate these steps.
August 6, 2008 at 4:47 am
usig move to option it is possible
August 6, 2008 at 7:40 am
I let that be the programmers problem....
After overwritting their code once, they become much better at keeping copies of it =)
I also use ApexSQL Diff when there is code I know I need to save, but in general whenever I restore to the test or development environment, it is up to the developers/testers to keep scripts to get the database up to where they want it.
August 7, 2008 at 7:20 am
Hello,
Download trial of ScriptLogics's LiteSpeed SQL and use the Object Level Recovery tool to back up single objects in the database.
Here is the link : http://www.scriptlogic.com/products/litespeed/
This should do the trick!
Let me know!
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply