I Cannot Backup The Transaction Log - SQL Server 2000

• David Boardman

  SSC Enthusiast

  Points: 120

  More actions

  September 16, 2005 at 6:54 am

  #89046

  Hi All,

  I've been tearing my hair out with this one, so any help would be much appreciated.

  I cant backup the transaction log of my database in sql server 2000, be it through a maintanence plan or direct db backup. In enterprise manager, if i right click the db and choose 'All Tasks' 'Backup Database', under the backup section, both 'transaction log' and 'file and group' are greyed out. I can backup the actual db without any problems.

  Any suggestions?

  Thanks in advance,

  Dave

• peterhe

  SSChampion

  Points: 11469

  More actions

  September 16, 2005 at 7:06 am

  #590549

  Check your recovery model. Are you in SIMPLE model?  In this case, the backup "transaction log" and "file and group" are disabled.

   

   

• David Boardman

  SSC Enthusiast

  Points: 120

  More actions

  September 16, 2005 at 7:22 am

  #590564

  Success! Thank you so much peterhe! It was in simple mode, ive chaged it to FULL as everything works fine.

  Cheers,

  Dave