dteshome
asked on
SQL Server 2005 stuck in restoring mode
Hi,
I restored a db from backup and applied logs to the last one, however, I forgot to do the last log with RECOVERY
I did the following to the last log:
RESTORE LOG CLAW
FROM DISK = 'E:\SQL\TempBackup\claw_20 1008181100 .trn'
WITH NORECOVERY
How do I bring the db to recovered mode?
Thanks,
D
I restored a db from backup and applied logs to the last one, however, I forgot to do the last log with RECOVERY
I did the following to the last log:
RESTORE LOG CLAW
FROM DISK = 'E:\SQL\TempBackup\claw_20
WITH NORECOVERY
How do I bring the db to recovered mode?
Thanks,
D
ALTER DATABASE database_name RECOVER
I believe you're going to have to rerun the entire restore and when you do the last log the use WITH RECOVERY.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
dba2dba
The "command" you gave (below) is not valid; no such ... in SQL Server
ALTER DATABASE database_name RECOVER
I was hoping that there was another, les "envasive" way than redoing! Anyone?
The "command" you gave (below) is not valid; no such ... in SQL Server
ALTER DATABASE database_name RECOVER
I was hoping that there was another, les "envasive" way than redoing! Anyone?
ASKER
Hi, cmangus:
Your sol'n (restore database claw with recovery ) worked.
Thanks,
Dan
Your sol'n (restore database claw with recovery ) worked.
Thanks,
Dan