Solved

MSSQL Server 2000

Posted on 2011-03-03
3
797 Views
Last Modified: 2012-05-11
Hello, I notice that one of my database has been in loading for quite a long time now. What can I do to stop this or what is causing this problem.
0
Comment
Question by:vera2006
[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
3 Comments
 
LVL 39

Expert Comment

by:Pratima Pharande
ID: 35024873
Go to task manager and End task to stop
0
 
LVL 13

Expert Comment

by:geek_vj
ID: 35024875
This might be due to various reasons. This may be due to disk issues or database was brought down abruptly so it is taking time to recover.
You can check error log for details behind this loading issue.
Please post the error from error log so that we can guide u better.
0
 
LVL 15

Accepted Solution

by:
Aaron Shilo earned 500 total points
ID: 35027275
hi

i encountered this issue after returning from a database backup.

if this is the issue then you should run this command:

RESTORE DATABASE XXXX WITH RECOVERY

0

Featured Post

Edgartown IT Case Study

Learn about Edgartown's quest to ensure the safety and security of the entire town's employee and citizen data. Read the case study!

Question has a verified solution.

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

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
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.

735 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