Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RE: DB Stuck in Restore Mode 1

Status
Not open for further replies.
allyne

allyne

MIS
Feb 9, 2001
410
US
Hello,

I have a database that is stuck in restore mode. Have not seen this before. How can I get this out of restore mode.....Luckily this is our test environment...

Thanks for all your help...
 
Sort by date Sort by votes
It might be the way you did the restore...it could be looking for an additional file. Try this: (change mydb to your database name)

Code: 
RESTORE DATABASE mydb
WITH RECOVERY

-SQLBill

The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

grnzbra
  • Locked
  • Question
SQL Server in Windows
Replies
1
Views
240
pjw001
pjw001
CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
215
CodeWell
CodeWell
intel233
  • Locked
  • Question
Backup/Restore DB from SQL issues
Replies
2
Views
99
intel233
intel233
TheBugSlayer
  • Locked
  • Question
High Availability - insert fails on primary replica but runs on secondary after failover.
Replies
0
Views
158
TheBugSlayer
TheBugSlayer
GCL2007
  • Locked
  • Question
Simple Recovery model - Huge Trans Log
Replies
0
Views
152
GCL2007
GCL2007

Part and Inventory Search

Sponsor

Back
Top