If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Sybase > no log segment for master db?

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 05-19-08, 17:42
amy7756 amy7756 is offline
Registered User
 
Join Date: Jul 2006
Posts: 28
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
Reply With Quote
  #2 (permalink)  
Old 05-20-08, 09:37
pdreyer pdreyer is offline
Registered User
 
Join Date: May 2005
Location: South Africa
Posts: 1,268
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
Reply With Quote
Reply

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On