cannot startup MS SQLSERVER

• lux-254120

  Valued Member

  Points: 66

  More actions

  October 31, 2005 at 12:20 am

  #115475

  Hi guys,

  I've tried to delete some records. It took x-amount of times, yet not complete.

  When I looked into current activity (Lock/process ID).

  It showed that other processes blocked that process.

  So, i decided to cancel query.

  After that I stopped and start SQL SERVER.

  But at this time, It cannot startup database. It was hang.

  When I check in task manager @ proceess tab, one process sqlservr.exe Memory usage is increasing untill out of memory usage.

  can anyone help?

  TIA,

  Lux

   

   

   

   

• Kory Becker

  Hall of Fame

  Points: 3585

  More actions

  October 31, 2005 at 9:29 am

  #601351

  Did the service actually stop or was it stopping? Check your logs, as it is probably rolling back, checkpointing or in recovery!

• lux-254120

  Valued Member

  Points: 66

  More actions

  November 1, 2005 at 2:04 am

  #601496

  It's work again.

  I think what you've mentioned are right.

  It's prolly rolling back.

  And when It was finished I can access to database normally.

  Thanks for your supoorts

  Cheers,

  Lux