in logshipping primary database is in suspect mode ,i have recent full backup but i dont have the jobs

• jyotitummala

  Newbie

  Points: 1

  More actions

  December 20, 2007 at 8:42 pm

  #70616

  hi,

  iam performing logshipping, my secondary machine is in deactivated state so i dont have restore job in it,in the mean while i found that my primary database is in suspect mode.

  can u plz give some ideas,

  can i directly restore the backup after removing suspect condition.

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  December 20, 2007 at 9:50 pm

  #761974

  Any error message from errorlog? Check why it is suspect.

• Vivien Xing

  SSChampion

  Points: 12297

  More actions

  December 20, 2007 at 9:57 pm

  #761976

  This link may help.

  http://www.sqlservercentral.com/articles/Administering/unmarksuspect/137/