Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

i'm trying to do point in time restore and following error occurs... and database goes into xxxxx(loading) state...

Backup set cannot be applied because it is on a recovery path inconsistent with database

i have to do RESTORE DATABASE xxxxx WITH RECOVERY to make it proper... Why its happening?

share|improve this question

migrated from stackoverflow.com Dec 5 '09 at 17:05

This question came from our site for professional and enthusiast programmers.

1 Answer 1

This sounds like you are restoring a database backup file (.BAK) rather than restoring a Transaction Log Backup file (.LOG) i.e. rolling a database foreward, from it's last FULL BACKUP, to a particular point in time.

Was the database, from which the original backup was taken, placed in the FULL Recover model and do you also have Transaction Log backups?

To qualify, a database backup file contains the database data at a specific point in time only. A database can only subsequently be rolled forward to a given point in time using Transaction Log Backups, sourced from the same database as the Full database backup.

share|improve this answer
    
I've appended transaction log to full backup file only. –  kv Dec 3 '09 at 14:14
    
Take a look at the following Documentation: msdn.microsoft.com/en-us/library/ms190244%28SQL.90%29.aspx –  John Sansom Dec 3 '09 at 16:14

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.