Post reply

SQL Server Backup and Restore

  • November 26, 2006 at 4:23 pm

    #115371

    Hi there,

    I am new to administration. i would like to create a development environment out of production database.

    for this i have to backup the production database on a regular basis. then use this backup and restore it to a database on different. i can do this task, but i want to automate this task to do it on regular basis.

    i would like to schedule my backup time. and immediately after backup i want to restore it to the database on other server, over writing existing data. what is the best way to do this???

    thanks,

    kishore

    delete

  • November 27, 2006 at 11:16 pm

    #674225

    Just create a job on your developement server to run the restore.

    Step1: Kill the connections in restoring db.

    Step2: Run the restore command.

    Step3: Create/Sync the db users...

     

    MohammedU

    MohammedU
    Microsoft SQL Server MVP

  • November 27, 2006 at 11:29 pm

    #674227

    I agree with Mohammad. Anything in the SQL Server is automated through Jobs only. Also, if you can do, create an operator to alert you in case some Job failed.

    Good luck.

    Pankaj Khanna
    Database Administrator - SQL Server 2000

    Keep hope to keep you intact...

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

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