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.
Showing posts with label editionthis. Show all posts
Showing posts with label editionthis. Show all posts
Monday, March 19, 2012
Differential Restore
Labels:
backup,
backups,
current,
database,
differential,
differentialtranlogs,
editionthis,
enterprise,
fullm-sat,
houri,
microsoft,
mysql,
oracle,
restore,
schedulesunday,
server,
sql,
sql2k,
win2k3
Subscribe to:
Posts (Atom)