Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2007
    Posts
    4

    Unanswered: dump transcation log with automatic

    Hi... all

    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.

    please.

  2. #2
    Join Date
    Sep 2003
    Location
    Switzerland
    Posts
    443
    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
    go
    Last edited by trvishi; 12-31-07 at 06:27.

  3. #3
    Join Date
    Dec 2007
    Posts
    4
    Thank's for answer my question trvishi... I'll try and looking for from sybase

Posting Permissions

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