Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

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.

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.