Results 1 to 3 of 3

Thread: Transaction Log not dumping despite all knowledgeable efforts

  1. #1
    Robert Guest

    Transaction Log not dumping despite all knowledgeable efforts

    The transaction log does not truncate despite all
    attempts (no_log,truncate_only, etc...) This database is a subscriber
    for replication. Tried the reconfigure with override.
    There are no open transactions (dbcc opentran)

    Need help fast !!!

    Danke schoen


  2. #2
    Joey Guest

    Transaction Log not dumping despite all knowledgeable efforts (reply)

    If you already haven't then run

    dbcc checkdb
    and then
    dump tran 'dbname' with no_log


    ------------
    Robert at 9/7/99 7:18:21 PM

    The transaction log does not truncate despite all
    attempts (no_log,truncate_only, etc...) This database is a subscriber
    for replication. Tried the reconfigure with override.
    There are no open transactions (dbcc opentran)

    Need help fast !!!

    Danke schoen


  3. #3
    Ray Miao Guest

    Transaction Log not dumping despite all knowledgeable efforts (reply)

    Run 'dbcc checktable (syslogs)'.


    ------------
    Joey at 9/8/99 3:57:01 AM

    If you already haven't then run

    dbcc checkdb
    and then
    dump tran 'dbname' with no_log


    ------------
    Robert at 9/7/99 7:18:21 PM

    The transaction log does not truncate despite all
    attempts (no_log,truncate_only, etc...) This database is a subscriber
    for replication. Tried the reconfigure with override.
    There are no open transactions (dbcc opentran)

    Need help fast !!!

    Danke schoen


Posting Permissions

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