DATABASE IN SUSPECT\OFFLINE MODE

• nikhil.verma

  SSCrazy

  Points: 2603

  More actions

  August 13, 2008 at 2:23 pm

  #70640

  Hi

  One of my production servers is using SQL SERVER 7.0 . Few Days back my database was turned offline as per the request i got. And meanwhile my server was restarted . Now on Database it is showing Supect\Offline. Can anyone please help out on this , as again i need to turn my database to the online mode.

  I tried using sp_dboption 'dbname','offline','false' , but failed to acheive anyting with this.

  Any help would be highly appreciated.

  Nik

• MANU-J.

  SSC-Dedicated

  Points: 31126

  More actions

  August 13, 2008 at 4:13 pm

  #857766

  Try using:-

  Right click database-->All Tasks--Bring Database Online.

  MJ