March 12, 2010 at 1:41 pm
F. van Ruyven (3/12/2010)
The following works for me:* Create a new database 'MyDB_SourceBackup'
* Copy all definitions (tables, sp's etc.) from MyDB to MyDB_SourceBackup (using SQLCompare)
* Restore a full backup from production to MyDB
* Copy all definitions from MyDB_SourceBackup to MyDB (using SQLCompare)
That seems a bit of a procedure for taking copies of an environment. I just have an agent job that just takes the last backup of the live environment, copies it to the dev server, and restores it to there, then runs additional scripts to makes sure the logins work properly..
March 12, 2010 at 4:01 pm
copies it to the dev server,
You can eliminate this step also, only thing you need to do is ask your network team to open a port one way to see production fileshare from Dev SQL server machine, they do this by IP address in firewall. You can do restores without copying back up file to dev environment, we are using this method almost for a year.
Viewing 2 posts - 16 through 16 (of 16 total)
You must be logged in to reply to this topic. Login to reply