Solved

SQL Server 2005 stuck in restoring mode

Posted on 2010-08-19
5
307 Views
Last Modified: 2012-05-10
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
Comment
Question by:dteshome
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
5 Comments
 
LVL 8

Expert Comment

by:dba2dba
ID: 33479650
ALTER DATABASE database_name RECOVER
0
 
LVL 17

Expert Comment

by:Chris Mangus
ID: 33479678
I believe you're going to have to rerun the entire restore and when you do the last log the use WITH RECOVERY.
0
 
LVL 17

Accepted Solution

by:
Chris Mangus earned 125 total points
ID: 33479776
I asked my cohort here at work and found that they have used RESTORE DATABASE [Log Claw] WITH RECOVERY with marginal success.
0
 

Author Comment

by:dteshome
ID: 33479984
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
 

Author Comment

by:dteshome
ID: 33480056
Hi, cmangus:

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

Thanks,
Dan
0

Featured Post

Forrester Webinar: xMatters Delivers 261% ROI

Guest speaker Dean Davison, Forrester Principal Consultant, explains how a Fortune 500 communication company using xMatters found these results: Achieved a 261% ROI, Experienced $753,280 in net present value benefits over 3 years and Reduced MTTR by 91% for tier 1 incidents.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
Via a live example combined with referencing Books Online, show some of the information that can be extracted from the Catalog Views in SQL Server.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties

696 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question