Results 1 to 2 of 2
  1. #1
    Join Date
    Jun 2003
    Posts
    50

    Unanswered: What happens when Master Transaction Log Fills up

    Hi,

    The Master Transaction Log filled up.
    I did a dump transaction with no_log to free it up
    Just wondering, would that cause access to the databases on that sybase
    server to degrade.

    Thanks,
    Dave

  2. #2
    Join Date
    Feb 2002
    Location
    Willy is on vacation
    Posts
    1,208
    When master tran log is full, new users can't login. Existing users continue to work. The only reason this would happen is because users are running transactions in master rather than user database. Change the default database for all logins from master to something else. Also change the default disk device from master device to a user device.

Posting Permissions

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