Post reply

SQL Server Backup and Restore

  • 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 2 posts - 1 through 3 (of 3 total)

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