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_201008181100.trn'
WITH NORECOVERY

How do I bring the db to recovered mode?

Thanks,
D
dteshomeAsked:
Who is Participating?
 
Chris MangusConnect With a Mentor Database AdministratorCommented:
I asked my cohort here at work and found that they have used RESTORE DATABASE [Log Claw] WITH RECOVERY with marginal success.
0
 
dba2dbaCommented:
ALTER DATABASE database_name RECOVER
0
 
Chris MangusDatabase AdministratorCommented:
I believe you're going to have to rerun the entire restore and when you do the last log the use WITH RECOVERY.
0
 
dteshomeAuthor Commented:
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?
0
 
dteshomeAuthor Commented:
Hi, cmangus:

Your sol'n (restore database claw with recovery )  worked.

Thanks,
Dan
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.