Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Enlarge the database

2 posts in Windows NT Last posting was on 2000-07-09 14:55:27.0Z
Howard Wong Posted on 2000-07-07 03:27:32.0Z
From: "Howard Wong" <howardwong@loyaltex.apparel.com.hk>
Subject: Enlarge the database
Date: Fri, 7 Jul 2000 11:27:32 +0800
Lines: 4
Organization: Loyaltex
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6600
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
Message-ID: <y7nK9Q85$GA.86@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: ipvpn005213.netvigator.com 203.198.56.213
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1930
Article PK: 1089367

How can I enlarge the database value when I have used up all including
logging??


Andy Price Posted on 2000-07-09 14:55:27.0Z
From: "Andy Price" <andy.price@canada.com>
References: <y7nK9Q85$GA.86@forums.sybase.com>
Subject: Re: Enlarge the database
Date: Sun, 9 Jul 2000 15:55:27 +0100
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
Message-ID: <fQoPdbb6$GA.204@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: dyn100-ras39.screaming.net 212.188.134.100
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:1919
Article PK: 1089353

Howard,

Create new devices for log and data (if there is no more space) and then
extend the data and log onto those devices. Remember that the max number of
fragments for a database is 128. If you have reached this, then you may
benefit from bcp out of all database, recreating the database with one data
and one log fragment for example, and then bcp back in. If you have less
than 128 fragments, then you can just extend onto a device with free space.

I hope that helped.

Andy

--
Andy Price
Sybase Certified Adaptive Server DBA - Associate v12.0 & v11.5

"Howard Wong" <howardwong@loyaltex.apparel.com.hk> wrote in message
news:y7nK9Q85$GA.86@forums.sybase.com...
> How can I enlarge the database value when I have used up all including
> logging??
>
>