Re: Detaching and Attaching Standby Database

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

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

Date: Thu, 5 Aug 2004 08:44:36 -0400

In article <#b#zEYueEHA.1036@TK2MSFTNGP10.phx.gbl>, urid@iscar.co.il
says...
>
> "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.
>
> Have you read the article in the BOL
> "How to set up, maintain, and bring online a standby server (Transact-SQL)"?

Yes, I've read that and I have all of that working. The problem is that
I really want to just keep restoring logs on this server, but I want to
have a local backup of the standby database (45GB production database is
on the west coast and I am on the east with only a T1 between the two).
Yesterday I had some kind of disk hiccup during a log restore and the
standby database was hosed so I have to go back to a 1.5 week old full
backup and a ton of log restores. If I could just automatically backup
(full) the standby database each night my restore issue would be much
smaller. I understand that I can't do an actual backup, but I should be
able to detach, copy and attach or something like that.

Relevant Pages

  • Re: Detaching and Attaching Standby Database
    ... >> Have you read the article in the BOL ... > have a local backup of the standby database (45GB production database is ... > Yesterday I had some kind of disk hiccup during a log restore and the ... > backup and a ton of log restores. ...
    (microsoft.public.sqlserver.server)
  • Re: standby database on standard edition (once again) 10g
    ... I try to follow procedure from Oracle Data Guard Concepts and ... Administration, chapter 3 Creating a Physical Standby Database, ... unfortunetly still dont know how should I create stanby from backup ...
    (comp.databases.oracle.server)
  • Re: Dataguard
    ... automatically for instance i want to delete one month archived log ... from primary and standby database with out RMAN. ... I am not using RMAN at all. ... backup weekly and hot backup daily. ...
    (comp.databases.oracle.misc)
  • Re: How to backup a standby database
    ... application against the activated standby database. ... > Need smaller SQL2K backup files? ... My standby environment is remote, ... >> then I transmit logs using an encrypted secure shell internet transfer. ...
    (microsoft.public.sqlserver.server)
  • Detaching and Attaching Standby Database
    ... 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 ... I thought about doing a NET STOP MSSQLSERVER, backup files, and NET ...
    (microsoft.public.sqlserver.server)