Re: Backup up warm-standby server

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: Narayana Vyas Kondreddi (answer_me_at_hotmail.com)
Date: 08/31/04 

Date: Tue, 31 Aug 2004 21:32:49 +0100

Instead of trying to backup the database that is constantly recovering, why
not add another target server to your logshipping configuration? 

-- 
Vyas, MVP (SQL Server)
http://vyaskn.tripod.com/
"anonymous" <a@b.bad> wrote in message
news:%23QWkYf5jEHA.3852@tk2msftngp13.phx.gbl...
> Hello all-
> We have a two databases, BoxA and BoxB.  BoxA is the live production
server
> and BoxB is a backup server that we do log shipping to.
>
> Every couple of hours we ship logs from BoxA to BoxB.  BoxB is a warm
> standby SQL server.
>
> We would like to backup BoxB, the warm standby, however we receive the
> following error message:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC
SQL
> Server Driver][SQL Server]Database '' is in warm-standby state (set by
> executing RESTORE WITH STANDBY) and cannot be backed up until the entire
> load sequence is completed.
> [Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is
> terminating abnormally.
> "
>
> Now is there any easy way to backup the database on BoxB without dropping
> the maintenance plans?
>
> Any help would be greatly appreciated.
>
>

Relevant Pages

  • RE: How do I restore from mdf and ldf files?
    ... Tasks -> Backup Database ... Tasks -> Restore Database ... Windows 2003 Server with Latest Service Pack ... Pre-requisites for Sharepoint Backup and Restore: ...
    (microsoft.public.sharepoint.portalserver)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... newsgroups so that they can be resolved in an efficient and timely manner. ...
    (microsoft.public.windows.server.sbs)
  • RE: ESENT Logging
    ... SBS server 2003 has a backup job that will ... 145881 How to Use Jetpack.exe to Compact a WINS or DHCP Database ... Microsoft CSS Online Newsgroup Support ...
    (microsoft.public.windows.server.sbs)
  • RE: Backups have Shadow Copy Problems
    ... and restarted the server. ... suggested and changed the recovery model to simple on the one database called ... I understand the issue to be: the backup task failed ... You back up data from a volume that contains a Microsoft SQL Server ...
    (microsoft.public.windows.server.sbs)
  • RE: Adventures in Server restore
    ... SP1 for exchange change the db jet and should fix this problem ... > I thought I'd pass on my experience in bringing back an exchange server ... I'm not sure what happened (but a online backup was going on) ... > persists then please restore the database from a previous backup. ...
    (microsoft.public.exchange.admin)