September 8, 2004 at 9:12 am
Each morning we take the nightly backup of a live database and restore it to our test environment on another server which we then script up to the current test version. Is there a way we could automate this procedure inc the scripting? Apologies if this is very obvious, but I am just beginning DB Administration.
Ed Phillips
September 8, 2004 at 10:23 am
Need some method to move the backup file to the test server. If you name it the same thing on the test server each day, it makes things easier.
Next be sure that you get all users out of the database or you cannot restore. There are scripts on the site here that can do that.
Lastly, issue a restore database command, which can be in a job step. Using the same name each day means this is not a complicated command.
Run sp_change_users_login to resynch your logins and users.
September 9, 2004 at 2:13 am
Many thanks Steve. Have put in place and will be running tonight.
Ed Phillips
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply