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,
Tonyhttp://www.sql-server-performance.c...og_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
>|||You cannot do any type of backup of a database restored using either NORECOV
ERY or STANDBY. But you
should be prepared to do backups of that database the minute this becomes th
e 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
>|||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.c
om...
> 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
>
Showing posts with label alert. Show all posts
Showing posts with label alert. Show all posts
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
>
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
>
Friday, February 24, 2012
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
however the databases are in sync. and yes I do have sp3;
mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;
|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
however the databases are in sync. and yes I do have sp3;
mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;
|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
however the databases are in sync.
NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
> however the databases are in sync.
however the databases are in sync.
NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
> however the databases are in sync.
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed"
,
however the databases are in sync. and yes I do have sp3;mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
,
however the databases are in sync. and yes I do have sp3;mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point
to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> "failed" ,
>
>
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed"
,
however the databases are in sync.NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed
" ,
> however the databases are in sync.
,
however the databases are in sync.NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed
" ,
> however the databases are in sync.
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
however the databases are in sync.NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
> however the databases are in sync.
however the databases are in sync.NEVER MIND!! I just read knowledge base...DUH!! I forgot to upgrade to sp3
when i set up my testing environment.
"mrdj" wrote:
> the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
> however the databases are in sync.
Log shipping alerts
the "Log Shipping alert job-restore" job keeps showing a status of "failed" ,
however the databases are in sync. and yes I do have sp3;mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> > the "Log Shipping alert job-restore" job keeps showing a status of
> "failed" ,
> > however the databases are in sync. and yes I do have sp3;
>
>|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> > the "Log Shipping alert job-restore" job keeps showing a status of
> "failed" ,
> > however the databases are in sync. and yes I do have sp3;
>
>
however the databases are in sync. and yes I do have sp3;mrdj - are there any entries in the system error log files that may point to
something?
"mrdj" <mrdj@.discussions.microsoft.com> wrote in message
news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> the "Log Shipping alert job-restore" job keeps showing a status of
"failed" ,
> however the databases are in sync. and yes I do have sp3;|||The only message is it states that the database is out of sync by XXX
minutes, which again does not make sense because as I run queries the
databases are in sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> > the "Log Shipping alert job-restore" job keeps showing a status of
> "failed" ,
> > however the databases are in sync. and yes I do have sp3;
>
>|||another interesting thing is that when i look in the Log Shipping Monitor
properties, although it shows the last backup file to be accurate, but for
the last file copied (and the last file loaded) it shows
"first_file_0000000000.trn" and the copy/load deltas show the same number of
minutes that the alert job claims to be out of sync.
"JD" wrote:
> mrdj - are there any entries in the system error log files that may point to
> something?
>
> "mrdj" <mrdj@.discussions.microsoft.com> wrote in message
> news:E3C18911-0003-48AE-8E93-9D97A4B3C25C@.microsoft.com...
> > the "Log Shipping alert job-restore" job keeps showing a status of
> "failed" ,
> > however the databases are in sync. and yes I do have sp3;
>
>
Log Shipping Alert Firing for database that no longer exists
I have an error 14421 (database has restore threshold for 45 minutes and has not restored in more than "so many" minutes)firing for a database that no longer exists. How can I remove this alert? I have other log shipping plans that are running and so I can't delete the Log shipping alert job.Okay - that was too easy - I've struggled with this for 2 days - ran a select on the table in msdb - found the row that was screwy, and deleted .... now all is fine. Gotta use that tsql every once in a while!
Subscribe to:
Posts (Atom)