Re: Transaction LOG Restore - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

SQL Server Administration (2005)

Re: Transaction LOG Restore

Author

Topic

sql9.babu
Starting Member

21 Posts

Posted - 2008-02-11 : 01:21:31

Iam trying to restore Transaction Log backup, for this

I took Full backup, Differential backup & Transactional Log backup

then I tried to restore by process as...

restore recent Fullbackup with norecovery,
restore recent Differential with norecovery,
restore Transaction Log backup with recovery

is that correct? if not tell me the ordersequence

Iam trying this but when executing the program Iam getting the error like my Database(DB) is inconsistant......... with this error msg.

Msg 4330, Level 16, State 1, Line 1
This backup set cannot be applied because it is on a recovery path that is inconsistent with the database. The recovery path is the sequence of data and log backups that have brought the database to a particular recovery point. Find a compatible backup to restore, or restore the rest of the database to match a recovery point within this backup set, which will restore the database to a different point in time. For more information about recovery paths, see SQL Server Books Online.
Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.

I understood that the problem is while restoring my Transactional log backup the DB is still showing in restoring...process...

I have to come out of the procedure and restore the fullBackup with norecovery & recent full logbackup with recovery to come out of that (restore processing...)

pls sugest me the order while taking the backup and while restoring.

thanx for any help

CShaw
Yak Posting Veteran

65 Posts

Posted - 2008-02-11 : 18:42:16

Did you only do the most recent T-Log backup? If there were multiple T-Logs it should look like this.

restore recent Fullbackup with norecovery,
restore recent Differential with norecovery,
restore Transaction Log backup with norecovery,
restore Transaction Log backup with norecovery,
restore Transaction Log backup with recovery

Chris Shaw
www.SQLonCall.com

sql9.babu
Starting Member

21 Posts

Posted - 2008-02-12 : 02:47:06

thank u very much cshaw, I got the result

CShaw
Yak Posting Veteran

65 Posts

Posted - 2008-02-12 : 10:41:20

Glad that it helped.

Chris Shaw
www.SQLonCall.com

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources