Restore of Production DB to Test on another Server

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

SQL Server Administration (2000)

Restore of Production DB to Test on another Server

Author

Topic

vaddi
Posting Yak Master

145 Posts

Posted - 2006-10-02 : 12:27:15

Hello,

I need to do refresh/restore from production Database to Test database which is on another sql server. I used to use to the OEM. But now I need to do it more frequently.

So, can I get any generic script which I can schedule for the resotres. The backups are taken on the production server. So, the script should be most probably including removing the files , ftp to the production server, moving the files to the test and user logins.

Thanks

Kristen
Test

22859 Posts

Posted - 2006-10-02 : 12:37:42

Its the question of the day! Perhaps you'd like to join in over at:

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=72846

Kristen

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2006-10-02 : 17:47:20

Analyze your problem and write a simple script to refresh from PRD to DEV.

1. Find the latest Backup set and Copy from PRD to DEV/TEST
2. Backup old DEV, Refresh with the copied PRD backup. (Kill any users a still accessu=ing DB)
3. Sync Users
4. Schedule this job on DEV ONLY

With Regards
BSR

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-10-02 : 18:53:59

please refer to the thread that Kristen linked to. There is a link to a stored procedure that does exactly what you need.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources