Results 1 to 2 of 2
  1. #1
    Join Date
    Nov 2004

    Question Unanswered: Restore Master Database - Permisssions?

    I have 2 database servers, 1 @ production and 1 @ DR site.

    To restore the master database to DR on a regular basis, I have to rely on either the DBA or SysAdm to perform the restore. It's pretty expensive, as they have to dedicate some time to do so.

    I'm exploring the possibility of getting the Data Centre staff to do this instead, as they are stationed at the DR site. Please advise the SQL permisssions required to restore master database.

    We are running SQL Server 2000.

  2. #2
    Join Date
    May 2003
    Its sa only......and unless you trust the DR people, I would be reluctant to have the sa pasword widely known....

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts