MS SQL Server - MY DB starts Slowly.

You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author

MY DB starts Slowly.

cdmcdm2003@163.com

2006-01-12, 8:23 pm

when restarting my windows 2000 server after log on it takes about 2
hours for my Sqlserver 2000 DB to fully start. It used to take less
than a minute. any ideas?

i already use Command (DBCC) check my DB,but not find any Errors.

John Bell

2006-01-13, 7:23 am

Hi

What does the SQL Server log say? SQL Server will try to rollback
uncommitted transactions when it starts, which may take some time, therefore
you may want to check that you are handling transactions correctly in your
applications.

John

"cdmcdm2003@163.com" wrote:

>
> when restarting my windows 2000 server after log on it takes about 2
> hours for my Sqlserver 2000 DB to fully start. It used to take less
> than a minute. any ideas?
>
> i already use Command (DBCC) check my DB,but not find any Errors.
>
>

Sponsored Links