Restoring databases to alternate server

• Brian Sutherland

  SSC Enthusiast

  Points: 156

  More actions

  September 4, 2003 at 8:44 pm

  #106030

  Hello All,

  I am working through our Disaster Recovery Process (DRP) using BrightStor

  Enterprise Backup (Ver10 SP4).

  One of the scenarios I am looking at is restoring a user database to an alternate server.

  How are people capturing existing windows group memberships and sql login info that may be required during a restore to another server which doesnt have the same master database.

  Thanks, Brian

• growl

  Hall of Fame

  Points: 3068

  More actions

  September 4, 2003 at 10:23 pm

  #472721

  Hi Brian I found this very useful.

  http://www.databasejournal.com/features/mssql/article.php/2228611

  Microsoft has also some info in there knowledge base

  http://support.microsoft.com/default.aspx?scid=kb;en-us;246133#4

  Cheers