Hi-
SQL 2000
Win 2k sp4
We have created a maintenance plan to ship one of our databases to a
secondary server. The initial snapshop shipped fine but we get error 4305
when trying to apply subsequent shipped tran logs.
The error says that the transaction log is too new.
We have another maintenance plan running on this DB that does backing
up(complete and tran logs) and it did do a tran-log backup after the
log-shipping snapshot. The log-shipping plan then made a tran log backup and
shipped it(which is too new).
I am trying to clarify if we can have two maintenance plans on the same
db(one for backup and one for log-shipping). Is this is what is causing this
error since they are overlapping.
I have not been able to find any info on this and am inclined to think they
are and I can only have oneplan that does all the backing up and the
log-shipping.
Can anyone confirm?
Thanks.Hi
With log shipping, you can do a Full and Differential backup at any time,
but transaction logs are sacred. Only log shipping can do the logs, otherwise
you would loose transactions.
Regards
Mike
"Jez" wrote:
> Hi-
> SQL 2000
> Win 2k sp4
> We have created a maintenance plan to ship one of our databases to a
> secondary server. The initial snapshop shipped fine but we get error 4305
> when trying to apply subsequent shipped tran logs.
> The error says that the transaction log is too new.
> We have another maintenance plan running on this DB that does backing
> up(complete and tran logs) and it did do a tran-log backup after the
> log-shipping snapshot. The log-shipping plan then made a tran log backup and
> shipped it(which is too new).
> I am trying to clarify if we can have two maintenance plans on the same
> db(one for backup and one for log-shipping). Is this is what is causing this
> error since they are overlapping.
> I have not been able to find any info on this and am inclined to think they
> are and I can only have oneplan that does all the backing up and the
> log-shipping.
> Can anyone confirm?
> Thanks.
>
>|||Thanks Mike for quick response
jez.
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:BD6B7EE8-97DA-4522-B201-0494A27C54F0@.microsoft.com...
> Hi
> With log shipping, you can do a Full and Differential backup at any time,
> but transaction logs are sacred. Only log shipping can do the logs,
> otherwise
> you would loose transactions.
> Regards
> Mike
> "Jez" wrote:
>> Hi-
>> SQL 2000
>> Win 2k sp4
>> We have created a maintenance plan to ship one of our databases to a
>> secondary server. The initial snapshop shipped fine but we get error 4305
>> when trying to apply subsequent shipped tran logs.
>> The error says that the transaction log is too new.
>> We have another maintenance plan running on this DB that does backing
>> up(complete and tran logs) and it did do a tran-log backup after the
>> log-shipping snapshot. The log-shipping plan then made a tran log backup
>> and
>> shipped it(which is too new).
>> I am trying to clarify if we can have two maintenance plans on the same
>> db(one for backup and one for log-shipping). Is this is what is causing
>> this
>> error since they are overlapping.
>> I have not been able to find any info on this and am inclined to think
>> they
>> are and I can only have oneplan that does all the backing up and the
>> log-shipping.
>> Can anyone confirm?
>> Thanks.
>>
Showing posts with label secondary. Show all posts
Showing posts with label secondary. Show all posts
Friday, March 9, 2012
Sunday, February 26, 2012
Error 3036 during Backup
I encounter this error during backup from a log shipping secondary server. I've set up log shipping between a production server and a secondary server, all work fine. Now I want to use the secondary server or the warm standby server to do complete databas
e backup every night, since I want to off load the backup from the production server, however, I get this error message for the DB backup job:
"
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is comple
ted.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
"
My settings are:
the restore job runs from 10:15am till 8:45 am next day, then the DB backup job starts at 9:10am. So the two jobs are not overlapping each other. However, even if I manually run the back up job at times after 9:10am, it fails with the same error message.
I am wondering if there is any extra setting I need to set to make it work.
Thank you for any help
You cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC
SQL Server Driver][SQL Server]Database 'aspnetforums' 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.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
e backup every night, since I want to off load the backup from the production server, however, I get this error message for the DB backup job:
"
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' is in warm-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed up until the entire load sequence is comple
ted.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE is terminating abnormally.
"
My settings are:
the restore job runs from 10:15am till 8:45 am next day, then the DB backup job starts at 9:10am. So the two jobs are not overlapping each other. However, even if I manually run the back up job at times after 9:10am, it fails with the same error message.
I am wondering if there is any extra setting I need to set to make it work.
Thank you for any help
You cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC
SQL Server Driver][SQL Server]Database 'aspnetforums' 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.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
Error 3036 during Backup
I encounter this error during backup from a log shipping secondary server. I
've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby se
rver to do complete databas
e backup every night, since I want to off load the backup from the productio
n server, however, I get this error message for the DB backup job:
"
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft]
91;ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' is in warm
-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed
up until the entire load sequence is comple
ted.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s terminating abnormally.
"
My settings are:
the restore job runs from 10:15am till 8:45 am next day, then the DB backup
job starts at 9:10am. So the two jobs are not overlapping each other. Howeve
r, even if I manually run the back up job at times after 9:10am, it fails wi
th the same error message.
I am wondering if there is any extra setting I need to set to make it work.
Thank you for any helpYou cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODB
C
SQL Server Driver][SQL Server]Database 'aspnetforums' 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[/col
or]
terminating abnormally.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby se
rver to do complete databas
e backup every night, since I want to off load the backup from the productio
n server, however, I get this error message for the DB backup job:
"
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft]
91;ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' is in warm
-standby state (set by executing RESTORE WITH STANDBY) and cannot be backed
up until the entire load sequence is comple
ted.
[Microsoft][ODBC SQL Server Driver][SQL Server]BACKUP DATABASE i
s terminating abnormally.
"
My settings are:
the restore job runs from 10:15am till 8:45 am next day, then the DB backup
job starts at 9:10am. So the two jobs are not overlapping each other. Howeve
r, even if I manually run the back up job at times after 9:10am, it fails wi
th the same error message.
I am wondering if there is any extra setting I need to set to make it work.
Thank you for any helpYou cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODB
C
SQL Server Driver][SQL Server]Database 'aspnetforums' 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[/col
or]
terminating abnormally.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
Error 3036 during Backup
I encounter this error during backup from a log shipping secondary server. I've set up log shipping between a production server and a secondary server, all work fine. Now I want to use the secondary server or the warm standby server to do complete database backup every night, since I want to off load the backup from the production server, however, I get this error message for the DB backup job
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' 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
My settings are
the restore job runs from 10:15am till 8:45 am next day, then the DB backup job starts at 9:10am. So the two jobs are not overlapping each other. However, even if I manually run the back up job at times after 9:10am, it fails with the same error message. I am wondering if there is any extra setting I need to set to make it work.
Thank you for any helpYou cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC
SQL Server Driver][SQL Server]Database 'aspnetforums' 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.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC SQL Server Driver][SQL Server]Database 'aspnetforums' 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
My settings are
the restore job runs from 10:15am till 8:45 am next day, then the DB backup job starts at 9:10am. So the two jobs are not overlapping each other. However, even if I manually run the back up job at times after 9:10am, it fails with the same error message. I am wondering if there is any extra setting I need to set to make it work.
Thank you for any helpYou cannot backup a database that is in a non recovered state such as one
that you are log shipping too. Even if you recovered it and backed it up and
then restored it with no recovery, you would break the log chain
--
HTH
Jasper Smith (SQL Server MVP)
I support PASS - the definitive, global
community for SQL Server professionals -
http://www.sqlpass.org
"Yi" <s_anyi@.yahoo.com> wrote in message
news:9C44B865-DF9C-4C0F-9814-95EA3EC1E1F7@.microsoft.com...
> I encounter this error during backup from a log shipping secondary server.
I've set up log shipping between a production server and a secondary server,
all work fine. Now I want to use the secondary server or the warm standby
server to do complete database backup every night, since I want to off load
the backup from the production server, however, I get this error message for
the DB backup job:
> "
> [Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 3036: [Microsoft][ODBC
SQL Server Driver][SQL Server]Database 'aspnetforums' 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.
> "
> My settings are:
> the restore job runs from 10:15am till 8:45 am next day, then the DB
backup job starts at 9:10am. So the two jobs are not overlapping each other.
However, even if I manually run the back up job at times after 9:10am, it
fails with the same error message. I am wondering if there is any extra
setting I need to set to make it work.
> Thank you for any help
>
>
>
Subscribe to:
Posts (Atom)