Post reply

Automated Backup and Restoration between two servers

  • May 16, 2008 at 9:18 am

    #185612

    Hi,

    I am facing a situation where in I have a Test Server and a development server. Right now end users are doing a UAT on the test server and they report the issue using our Issue tracking system. What I want is to have a process that will automate the back up from the Test Server and restore it on the Dev Server. Both these servers are 2005 Standard Editions

    Thanks

    Vinoj

  • May 16, 2008 at 9:25 am

    #816585

    you can snapshot replicate everything.

    You can log ship, but that might cause issues with continuing updates.

    You can automate the backup, write a script to copy the file (use the same destination name) and then set a job that does the restore automatically.

    There are many ways to do this, but I'd recommend you doing it manually, documenting the steps, and then automating each one.

  • May 16, 2008 at 1:10 pm

    #816693

    Yeah, I've done this many times, and scripting it is not only fairly easy, it's proven. Just script the backup, then script the copy, then the restore. take them in small chunks and you'll have it done in less than a day.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

  • May 16, 2008 at 2:39 pm

    #816739

    Thanks for the input. I managed to get it done. created 2 jobs, the first one to back up and the second one to restore. Each runs on seperate servers. The second job initially checks for the existence of the backup and if it finds it then it will do the restore..

    Vinoj

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply