rufusman21


How to verify the "Full" backups of an online database.

  • Running MS SQL 2005 on Windows 2003 server using windows domain authentication
  • Obtaining nightly backups of the application databases & the system databases
  • Installed MS SQL 2005 Express SP2 on a workstation
My task is to take the FULL BAK file(s) and recreate the database on the workstation for Disaster Recovery verification.
  • What parameters do I need to tweak
  • Do I need to import the System databases from the server
  • What security issues must be satisfied to connect on the new machine





Re: Disaster Recovery - How to verify my 2005 standard databases using 2005 express

Buck Woody - MSFT


Good questions. I'll answer those below, but I wonder if another method might satisfy what you're really after. If you're looking for a standby system, then use Database Mirroring or Log Shipping or Clustering. All of these will fit the bill.

But on to your specific questions:

First, you can backup a SQL Server 2005 database on any edition and transfer it to another. Certain things work differently in certain editions however, such as replication, database mirroring and so on. You want to ensure that your applications don't depend on those features.

Second, Books Online has several references for moving system databases. Just search for "system databases" and you'll see what you need. It's important to note that you normally don't want to transfer your system databases to another server - the names of the servers and file locations will be different and so on. Backing them up is a good idea, but you don't want to transfer them.

Third, to connect to the second system, you'll need to fix the security in the database.

Buck Woody







Re: Disaster Recovery - How to verify my 2005 standard databases using 2005 express

rufusman21

How does one fix the security problems in the second server

Is there a formula or a list of parameters to change








Re: Disaster Recovery - How to verify my 2005 standard databases using 2005 express

Buck Woody - MSFT

Do a live.com search on "SQL Server Orphaned Accounts".






Re: Disaster Recovery - How to verify my 2005 standard databases using 2005 express

Deepak Rangarajan

In addition to Bucks comments refer these articles,

www.msdn2.microsoft.com/en-us/library/ms175475.aspx

http://sql-articles.com/articles.php pageNum_alltop=1&totalRows_alltop=13

http://sql-articles.com/articles.php pageNum_alltop=0&totalRows_alltop=13

http://deepakinsql.blogspot.com/2007/08/moving-system-databases-in-sql-2005.html

Thanxx
Deepak