Post reply

DOS Command or Toolto perform Database Restore (sql2000 or 2005) as required in TEST enviroment.

  • July 29, 2012 at 9:03 pm

    #259509

    hi,

    My issue:

    User are testing changes to the production database (LIVE) in a test database (TEST), this is a restored copy of production database (LIVE).

    I need to have a method that users can run from the PC that will restore a copy of LIVE to TEST only when they wish.

    The backup can be a day or so old.

    I could set up a daily backup of LIVE but, this would give me a standard .BAK file to restore. I need a script or other tool to give the control of the RESTORE to the user.

    The two database are on the same server.

    Thanks you for any help on this point,

    Kind regards,

    Eric

  • July 30, 2012 at 5:46 am

    #1519102

    I would probably set up a job within SQL Agent that does the backup, running as sys admin, and then give the users permission to execute the job (which can be done through the gui or through sqlcmd).

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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