[Webinar] Streamline your web hosting managementRegister Today

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 816
  • 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

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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