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

MSSQL Server 2000

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
vera2006
Asked:
vera2006
1 Solution
 
Pratima PharandeCommented:
Go to task manager and End task to stop
0
 
geek_vjCommented:
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
 
Aaron ShiloChief Database ArchitectCommented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

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