I've just tried it using TSQL and got exactly the same error. I'm thinking there might be some corruption somewhere. I'm going to remove the DB from the server and implement a new backup strategy on that box. Thankfully it is the only DB on that server.
Thanks to all for the help.
Blackie
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 2:57 PM
To: BLACK Greg
Subject: RE: Problem with recovery of transaction logs
should be straight forward (when compared to Oracle) try on the pubs db
first , tsql may show you a more useful error, SQL server is pretty much
like oracle in archivelog mode, ie restore db then restore archivelog files
/ transaction log backups in order.
All operations are logged in full recovery mode so there should be an issue,
mmm
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 3:41 PM
To: Richard Ridge
Subject: RE: Problem with recovery of transaction logs
Just this one at the moment. I'm just hoping like hell I never need to roll
this forward. Thanks for your help.
Blackie
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 2:36 PM
To: BLACK Greg
Subject: RE: Problem with recovery of transaction logs
got me buggered then, is it just this db that you are having the problem
with or any db you try to do a recovery on?
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 3:33 PM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Unfortunately, I have been selecting the transaction log radio button.
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 2:18 PM
To: BLACK Greg
Subject: RE: Problem with recovery of transaction logs
nope but you sure you are choosing to restore a transaction log not a
database file? only thing I can think of ? See attached
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 3:05 PM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Doing the restore through EM. I've never done one using TSQL. I'm more
familiar with Oracle than SQLServer, so EM has been easier for me so far.
Is there something in the restore in TSQL that I cant do using the GUI ??
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 11:57 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
how are you doing the restore? through EM or TSQL
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 10:17 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Recovery mode is Full.
-----Original Message-----
From: Richard Ridge [mailto:[Email Address Removed] Thursday, 15 January 2004 8:58 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
check what recovery mode your database is in
-----Original Message-----
From: BLACK Greg [mailto:Greg.[Email Address Removed] Thursday, 15 January 2004 9:34 AM
To: LazyDBA.com Discussion
Subject: RE: Problem with recovery of transaction logs
Hi Anthony,
Thanks for the reply. The transaction log I'm trying to restore from is the
one that was backed up after the full backup that I recovered from, so I
doubt it would be from an older backup set. Fortunately we are only testing
our DR procedures and this is not a real recovery. But if we ever have to
use it, I'm stuffed with this DB, unless I sort this out. I have tried a
different backup from a different day, and tried to recover the trans log
that was backed up immediately after the full backup, and this also fails.
Blackie
-----Original Message-----
From: anthony.[Email Address Removed] [mailto:anthony.[Email Address Removed] Thursday, 15 January 2004 7:51 AM
To: BLACK Greg
Cc: LazyDBA.com Discussion
Subject: Re: Problem with recovery of transaction logs
Sorry, what am i saying.
The Transaction log.... could it be that this is from an older backup set,
could it have been made after the full backup was executed?
__________________________________________
Anthony Hand
DBA | Systems Integration
Aon Risk Services Australia Ltd
Ph: +61 2 9253 7516
Fax: +61 2 92537952
"BLACK Greg"
<Greg.[Email Address Removed] To: "LazyDBA.com
Discussion" <[Email Address Removed]
ell.com> cc:
bcc:
14/01/2004 05:38 Subject: Problem with
recovery of transaction logs
PM
Hi all,
I'm having a problem trying to restore a database using a full backup and
then applying transaction logs to roll forward. We are using SQL 2000 on
Win2000 server.
The steps I'm doing are
1. Recover database from full backup ( time of backup 22:30), leave DB in
R/O state able to restore additional trans logs - This works OK.
2. Attempt to roll forward by applying the 1st transaction log after the
backup - This fails with the following error ( The log in this backup set
cannot be applied because it is not on a recovery path consistent with the
database )
How can this be ?? I have done this on other DB's successfully, but it
will not work for this one. Are there any options etc that can be set to
stop me applying the trans log to the DB ??
Any help would be greatly appreciated.
Blackie
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] "The information contained in this email and any attached files
is strictly private and confidential. This email should be
read by the intended addressee only. If the recipient of this
message is not the intended addressee, please call Aon Risk
Services Australia, Aon Consulting, Aon Re Australia Ltd and
other associated Aon Companies on +61 2 92537000 and promptly
delete this email and any attachments.
The intended recipient of this email may only use, reproduce,
disclose or distribute the information contained in this email
and any attached files with Aon's permission. If you are not
the intended addressee, you are strictly prohibited from using,
reproducing, disclosing or distributing the information
contained in this email and any attached files.
Aon advises that this email and any attached files should be
scanned to detect viruses. Aon accepts no liability for loss
or damage (whether caused by negligence or not) resulting from
the use of any attached files."
---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
Get today's cartoon: http://www.LazyDBA.com
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page