Re: Detaching and Attaching Standby Database
From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/05/04
- Next message: Hugo Kornelis: "Re: Changind a Primary Key value"
- Previous message: Paulo Ferreira: "Re: Emergency Mode"
- In reply to: Brad: "Detaching and Attaching Standby Database"
- Next in thread: Brad: "Re: Detaching and Attaching Standby Database"
- Reply: Brad: "Re: Detaching and Attaching Standby Database"
- Messages sorted by: [ date ] [ thread ]
Date: Thu, 5 Aug 2004 15:17:03 +0200
Brad
Have you read the article in the BOL
"How to set up, maintain, and bring online a standby server (Transact-SQL)"?
"Brad" <brad@seesigifthere.com> wrote in message
news:MPG.1b7bedee1a217f72989689@news...
> 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.
- Next message: Hugo Kornelis: "Re: Changind a Primary Key value"
- Previous message: Paulo Ferreira: "Re: Emergency Mode"
- In reply to: Brad: "Detaching and Attaching Standby Database"
- Next in thread: Brad: "Re: Detaching and Attaching Standby Database"
- Reply: Brad: "Re: Detaching and Attaching Standby Database"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
