var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: dump transcation log with automatic
I'm Newbie in database, i want do some think with my replication server, exactly for my RSSD device, because device for my RSSD it's not Huge. how to do that when the device grow up and full.
You need to create a new device if your current device is all used up.
To create a new device, first find space. It depends whether you are using raw or filesystem.
Once you find space, you create the device using 'disk init' and to extend the database you use 'alter database'.
Please read up http://sybooks.sybase.com on these commands.
Just checked the heading and Im a bit confused. If you are looking to do automated log truncation in checkpoint, you need to set-up the db option 'trunc log on chkpt'.
sp_dboption 'dbname','trunc log on chkpt',true
Last edited by trvishi; 12-31-07 at 06:27.
Thank's for answer my question trvishi... I'll try and looking for from sybase