Post reply

I Cannot Backup The Transaction Log - SQL Server 2000

  • 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

  • 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.

     

     

  • 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

Viewing 3 posts - 1 through 3 (of 3 total)

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