Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2006
    Posts
    28

    Unanswered: no log segment for master db?

    Hey All -

    How is it possible that my master database has no log segment? IE:

    create database master on master = 6
    go
    alter database master on master = 9
    go
    alter database master on master = 25
    go

    Does this mean that data & log are competing for space? That seems really bad. Why does sybase allow databases to be created like this?

    Also, what options do I have if my log space on the master database fills? Will Dump tran with no_log clear things up?

    Thanks

  2. #2
    Join Date
    May 2005
    Location
    South Africa
    Posts
    1,365
    Provided Answers: 1
    Yes data and log is on the same segment
    There should be minimal log activity
    trunc log on checkpoint is not on for master so
    a dump with truncate or no_log will probably work

Posting Permissions

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