Post reply

Prevent loading over the wrong database

  • September 30, 2010 at 8:07 am

    #142101

    Is there a way to set somethng up where I can prevent someone from doing a restore over the wrong database?

    We have a few databases on the same server and I am nervous that the wrong database may get selected with doing a restore.

    thanks

  • October 1, 2010 at 9:03 am

    #1230288

    I think there is no easy way to set it. The most is developing your own interface to control backup/restore tasks.

    My advice is - do not use enterprise manager/management studio. Use scripting instead (check BOL for syntax). This will somehow minimize wrong db restore. Also, create a role for doing db backup/restore only and assign that role to users who are authorized to do the job.

    And, if there's change management procedures in your company, then you'll be able to document any work that needs system outages as well as backout plans if the work didn't turn out well.

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

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