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.Its sa only.....and unless you trust the DR people, I would be reluctant to have the sa pasword widely known...
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment