Win2K3 SQL2K Enterprise Edition
 This is my current backup schedule
 Sunday FULL
 M-Sat Differential
 TranLogs Backups every hour
 I am trying to restore to a point in time, specifically to the time
 right after my last Differentail backup. I am using Ent Manager for
 this. I have restored the Full with no recovery and then I select just
 the last Differential Backup for restore and I get the message
 Cannot apply the backup on device 'd:\abcd\diff' to database 'TEST'
 restore database is terminated abnormally
 Is there something wrong with my restore process. This is a qa
 environment that I am testing this on. I have added a lot of data to
 the database and then manual run the diffential job. Now I am trying
 to restore to this point but I keep getting this error. Any help would
 be appreciated.Please check the backup file you are using.
Thanks
Ajay Rengunthwar|||Ajay, Not sure what you mean exactly. I was able to restore my last
full backup. Both with and without recovery. I am just having trouble
restoring the differentials backup after that.
 
No comments:
Post a Comment