• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 315
  • Last Modified:

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
0
dteshome
Asked:
dteshome
  • 2
  • 2
1 Solution
 
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
 
Chris MangusDatabase AdministratorCommented:
I asked my cohort here at work and found that they have used RESTORE DATABASE [Log Claw] WITH RECOVERY with marginal success.
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

Featured Post

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now