Post reply

SQL 2000 take a long time to stop services

  • August 17, 2007 at 8:49 am

    #68917

    Hi, I am stopping the SQL services but it is taking an unusual long time to stop.  It normally take a few minutes to stop, today it is taking over 5 min and is still in a stopping stage.  I know the log file is large about 70GB.  Does this have anything to do with it?  Database is in simple recovery mode.

    thanks,

     

     

  • August 17, 2007 at 8:58 am

    #727669

    Normally, the sizes of log files do not affect stopping SQL services. But if there are some other jobs running against the server, the jobs may need to rollback. Rolling back jobs may take a long time.

  • August 17, 2007 at 8:59 am

    #727670

    There were no jobs running at the time. 

     

  • August 17, 2007 at 9:45 am

    #727686

    We are all set.  Although it took a long time to shut down and about 30min to recover the databases we are up and running....

  • August 18, 2007 at 10:09 pm

    #727855

    if it happens again, try exec sp_who2 to give you an idea of what is causing the problem...there's always a reason for sql server to "hang"..and it's usually something that needs to complete or rollback.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply