Results 1 to 5 of 5

Thread: Remove inactive entries from transaction log!

  1. #1
    Join Date
    Sep 2002
    Posts
    78

    Remove inactive entries from transaction log!

    Hi!
    I have a sql server 2000 SP 1 and when I go to back up a database (full backup, overwrite) using enterprise manager, the [Remove inactive entries from transaction log] option is grayed out. The database is set on Full recovery. I would liek to know why this option is grayed out ? Is this a bug ?
    Any help will be appreciated.

    Thanks

  2. #2
    Join Date
    Mar 2003
    Location
    Woking, UK
    Posts
    152
    I think it's only for backup transaction log, not for backup database.
    You Have To Be Happy With What You Have To Be Happy With (KC)

  3. #3
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Full backup does not truncate the transaction log, that's why it's grayed out.

  4. #4
    Join Date
    Sep 2002
    Posts
    78

    Remove inactive entries from transaction log

    Hi!
    The same option is enabled on my sql server 2000 SP 3 when I try to perform full backup. Why is that ?

  5. #5
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    Beats me, I see options enabled when trying to backup Pubs database which is in Simple recovery model.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •