Detaching and Attaching Standby Database

From: Brad (brad_at_seesigifthere.com)
Date: 08/05/04


Date: Thu, 5 Aug 2004 08:11:26 -0400

I need to be able to detach my standby database so I can back it up.
How do I reattach it and keep it from going through a recover (thus
breaking my log consistency with the production database)?

I thought about doing a NET STOP MSSQLSERVER, backup files, and NET
START MSSQLSERVER, but I'm not sure if that will work.