Friday, March 30, 2012

Log shipping Transactions Log backup on secondary server

Guys,
Right after I setup up log shipping, there are a few jobs created under
job on the secondary server called "Log Shipping Alert Job - Backup"
and "Transaction Log Backup Job for DB Maintenance Plan...".
Without doing anything I would get a red "X", meaning failed on the
"Log Shipping Alert Job -Backup". When I run execute the "Transaction
Log Backup Job for DB Maintenance Plan...", it would fail too. This
is under the secondary server.
Is this normal? If not, how do i fix this? Do people actually backup
the transaction log on the secondary server on a log shipping?
Thanks,
TonyYou cannot do any type of backup of a database restored using either NORECOVERY or STANDBY. But you
should be prepared to do backups of that database the minute this becomes the production database
(when a fail over is performed).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tractng@.gmail.com> wrote in message news:1147763695.248207.126980@.j33g2000cwa.googlegroups.com...
> Guys,
> Right after I setup up log shipping, there are a few jobs created under
> job on the secondary server called "Log Shipping Alert Job - Backup"
> and "Transaction Log Backup Job for DB Maintenance Plan...".
>
> Without doing anything I would get a red "X", meaning failed on the
> "Log Shipping Alert Job -Backup". When I run execute the "Transaction
> Log Backup Job for DB Maintenance Plan...", it would fail too. This
> is under the secondary server.
> Is this normal? If not, how do i fix this? Do people actually backup
> the transaction log on the secondary server on a log shipping?
>
> Thanks,
> Tony
>|||http://www.sql-server-performance.com/sql_server_log_shipping.asp
<tractng@.gmail.com> wrote in message
news:1147763695.248207.126980@.j33g2000cwa.googlegroups.com...
> Guys,
> Right after I setup up log shipping, there are a few jobs created under
> job on the secondary server called "Log Shipping Alert Job - Backup"
> and "Transaction Log Backup Job for DB Maintenance Plan...".
>
> Without doing anything I would get a red "X", meaning failed on the
> "Log Shipping Alert Job -Backup". When I run execute the "Transaction
> Log Backup Job for DB Maintenance Plan...", it would fail too. This
> is under the secondary server.
> Is this normal? If not, how do i fix this? Do people actually backup
> the transaction log on the secondary server on a log shipping?
>
> Thanks,
> Tony
>|||Tibor,
Just to clarify. You are saying I won't be able to do a backup when it
is in the standby state. When the fail over is performed, I should be
able to?
Thanks a lot,
Tony|||Yes.
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
<tractng@.gmail.com> wrote in message news:1147979332.349123.49520@.j55g2000cwa.googlegroups.com...
> Tibor,
> Just to clarify. You are saying I won't be able to do a backup when it
> is in the standby state. When the fail over is performed, I should be
> able to?
>
> Thanks a lot,
> Tony
>

No comments:

Post a Comment