Simple Restore Failing - 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

General SQL Server Forums

New to SQL Server Programming

Simple Restore Failing

Author

Topic

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-07-04 : 12:32:56

I Was just practicing with backups and i tried to Restore useing the following code:

Restore Database testDB from disk = 'C:\Test\MyTest\testDB.bak' with Replace, NoRecovery
Restore Database testDB from Disk = 'C:\Test\MyTest\testDB_Differential.bak' with NoRecovery
Restore Log testDB from Disk = 'C:\Test\MyTest\testDB_Log.trn' with Recovery

Which results in the following error:

Msg 4330, Level 16, State 1, Line 3
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 3
RESTORE LOG is terminating abnormally.

All 3 backups were taken 5 minutes apart with only one change being made after each backup.

It works fine if i leave out the third(transaction log) Restore.

Thanks for looking.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-04 : 13:36:44

Can you post exactly what you did to create those backups?

--
Gail Shaw
SQL Server MVP

Jay123
Yak Posting Veteran

54 Posts

Posted - 2010-07-04 : 17:35:39

They were just simple backup jobs set to go off 5 minutes apart. i cannot paste the exact code as i can not get into my sql server.

I know its unrelated but how do i get it back.
I installed the enterprise edition which i got out of my "microstsoft sql server 2005 implentation and maintenance self paced training kit" Book.

Whoud it work if i just uninstalled and reinstalled it. is there a better way to do it.

Thanks.

GilaMonster
Master Smack Fu Yak Hacker

4507 Posts

Posted - 2010-07-04 : 18:21:51

Without seeing exactly what you did during the backups, it's hard to say. Those restores should work fine.

As for how you get SQL Server back, no idea. Impossible to say without a lot more information as to what the problem is.

--
Gail Shaw
SQL Server MVP

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources