Database auto-recovery after server startup

Hi All,
There is a relative-large Database (>12GB in size) in my SQLServer. It
can run as usual without restarting pc machine. After reboot the machine,
the large database would automatically recover for a long time (more than 5
hours). What should the problem be and what can i do for it? Please give
some advice. Thank you !Hi,
As a initial step,
Before rebooting the server please stop the SQL Server service and once it
is sucessful you can restart the Machine.
The only issue I can forsee is " The machine should have been rebooted while
a huge batch process is going on". Due to this after reboot
the Rollback and Roll forward will happen and during this time the database
will be in recovaring status.
Thanks
Hari
MCDBA
"Derek" <dereklim@.southasiagroup.com.hk> wrote in message
news:#wlYpfO1DHA.1272@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> There is a relative-large Database (>12GB in size) in my SQLServer. It
> can run as usual without restarting pc machine. After reboot the machine,
> the large database would automatically recover for a long time (more than
5
> hours). What should the problem be and what can i do for it? Please give
> some advice. Thank you !
>|||Also check the sp_configure recovery interval in minutes,,, it probably
needs to be 0, or < 5.
Wayne Snyder, MCDBA, SQL Server MVP
Computer Education Services Corporation (CESC), Charlotte, NC
www.computeredservices.com
(Please respond only to the newsgroups.)
I support the Professional Association of SQL Server (PASS) and it's
community of SQL Server professionals.
www.sqlpass.org
"Derek" <dereklim@.southasiagroup.com.hk> wrote in message
news:%23wlYpfO1DHA.1272@.TK2MSFTNGP12.phx.gbl...
> Hi All,
> There is a relative-large Database (>12GB in size) in my SQLServer. It
> can run as usual without restarting pc machine. After reboot the machine,
> the large database would automatically recover for a long time (more than
5
> hours). What should the problem be and what can i do for it? Please give
> some advice. Thank you !
>