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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

database still loading

Status
Not open for further replies.
rq

rq

Programmer
Jun 13, 2002
56
0
0
US

Our office has a SQL Server database called DbLive. We successfully backed up DbLive via Enterprise Manager. Then, accessing DbTest we wanted to restore with DbLive backup. A day later DbTest is still loading. How can I resolve this?

 
Sort by date Sort by votes
You probably Restored using the WITH NORECOVERY option. So now it's waiting for the rest of the files to use in the recovery.

In Query Analyzer run this:
Code: 
USE dbname
GO
RESTORE dbname
WITH RECOVERY

Refer to the BOL for more information.

-SQLBill

BOL=Books OnLine=Microsoft SQL Server's HELP
Installed as part of the Client Tools
Found at Start>Programs>Microsoft SQL Server>Books OnLine

Posting advice: FAQ481-4875
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

CodeWell
  • Locked
  • Question
SQL Server 2017 Install Issue - Database Not in Configuration Manager
Replies
0
Views
104
CodeWell
CodeWell
baran121
  • Locked
  • Question
take a database from system databse place
Replies
2
Views
85
iambob
iambob
bethabernathy
  • Locked
  • Question
Front End Access 365 Database dsn Connection Fails when attempting to link to 2016 SQL server
Replies
1
Views
96
dhookom
dhookom
torquinian
  • Locked
  • Question
Error 0x80131904 when trying to connect to database
Replies
0
Views
75
torquinian
torquinian
RRinTetons
  • Locked
  • Question
Logging into a database using SSMS from non-domain machine
Replies
1
Views
107
fredericofonseca
fredericofonseca

Part and Inventory Search

Sponsor

Back
Top