Re: Detaching and Attaching Standby Database

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

From: Uri Dimant (urid_at_iscar.co.il)
Date: 08/05/04 

Date: Thu, 5 Aug 2004 16:00:13 +0200

Brad
I see what you mean
http://www.sql-server-performance.com/sql_server_log_shipping.asp

"Brad" <brad@seesigifthere.com> wrote in message
news:MPG.1b7bf5b3bb5a904198968a@news...
> 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
    ... >> I need to be able to detach my standby database so I can back it up. ... >> I thought about doing a NET STOP MSSQLSERVER, backup files, and NET ... Yesterday I had some kind of disk hiccup during a log restore and the ...
    (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)
  • Re: Detaching and Attaching Standby Database
    ... >> I really want to just keep restoring logs on this server, ... >> Yesterday I had some kind of disk hiccup during a log restore and the ... >> backup and a ton of log restores. ... But I can't do real log shipping because I am on standard. ...
    (microsoft.public.sqlserver.server)