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

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 workstationMy 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?

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

|||How does one fix the security problems in the second server?

Is there a formula or a list of parameters to change?|||Do a live.com search on "SQL Server Orphaned Accounts".|||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