November 26, 2002 at 7:40 am
Is there a way to stop the WITH NORECOVERY command? I'm restoring a database and it succeeded, but the differential restore is failing. Enterprise Manager shows the state of the database as (Loading). It is appearing to me that the differential backup may be corrupt. I want the database to exit the IN LOAD state and start up. I really don't want to have to begin all over again.
-Bill
November 26, 2002 at 8:26 am
I don't think your database is corrupt what was the last restore statement that you used.
John Zacharkan
John Zacharkan
November 26, 2002 at 8:41 am
This should have been posted under administration. You're in the developer land here.
John Zacharkan
John Zacharkan
November 26, 2002 at 8:47 am
SOrry about posting in the wrong place. The differential backup would not restore and of course the only error was that it couldn't be applied to the database. The only solution I have found is do the restore over, but this time after the full backup include WITH RECOVERY.
Thanks
-Bill
November 26, 2002 at 12:17 pm
Have you seen this example out of BOL - if you're not using devices - exchange it for disk = 'd:\adjhasdakj.trn'
Restoring a database, differential database, and transaction log backup
This example restores a database, differential database, and transaction log backup of the MyNwind database.
-- Assume the database is lost at this point. Now restore the full
-- database. Specify the original full backup and NORECOVERY.
-- NORECOVERY allows subsequent restore operations to proceed.
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH NORECOVERY
GO
-- Now restore the differential database backup, the second backup on
-- the MyNwind_1 backup device.
RESTORE DATABASE MyNwind
FROM MyNwind_1
WITH FILE = 2,
NORECOVERY
GO
-- Now restore each transaction log backup created after
-- the differential database backup.
RESTORE LOG MyNwind
FROM MyNwind_log1
WITH NORECOVERY
GO
RESTORE LOG MyNwind
FROM MyNwind_log2
WITH RECOVERY
GO
Cheers
John Zacharkan
John Zacharkan
December 3, 2002 at 10:21 am
John,
I did use those scripts. I know for a fact that my differential will not work with the fullbackup. However, I couldn't recover my database because I had used NORECOVERY, so it was still looking for more files. Apparently, there isn't any way to change it to WITH RECOVERY once you use WITH NORECOVERY (unless all the restores work and the last one has WITH RECOVERY). So, I had to begin the restore all over again.
I wish Microsoft would create a way to change the WITH NORECOVERY to WITH RECOVERY for circumstances like what I went through.
By the way, the issue was that the differential was the wrong one, it didn't go with the fullbackup that I restored. But like I said, once it failed, there is no way to change the status to RECOVERed vice NORECOVERY.
-Bill
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply