Backup up warm-standby server

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]&#
91;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 i
s
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.We just had a discussion about this. See the thread "How can I backup a log-
shipped database?".
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
"anonymous" <a@.b.bad> wrote in message news:%23QWkYf5jEHA.3852@.tk2msftngp13.phx.gbl...[vbcol
=seagreen]
> Hello all-
> We have a two databases, BoxA and BoxB. BoxA is the live production serve
r
> 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.
>[/vbcol]|||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][ODB
C
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.
>