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.

Extent the sybase device space

6 posts in Backup and Recovery Last posting was on 2001-05-22 20:34:47.0Z
Comrise Posted on 2001-05-04 18:43:02.0Z
Message-ID: <3AF2F836.110993A2@comrise.com>
Date: Fri, 04 May 2001 14:43:02 -0400
From: Comrise <peter.sun@comrise.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Extent the sybase device space
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 5
NNTP-Posting-Host: 209.191.2.117
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:273
Article PK: 1060791

Hi, all

My sybase SQL server's Database devie space just closing the limit, how
can I extend the space on SunOs?

Thanks in Advance.

Peter Sun


Bret Halford Posted on 2001-05-04 20:58:19.0Z
Message-ID: <3AF317EA.86830FB5@sybase.com>
Date: Fri, 04 May 2001 14:58:19 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Extent the sybase device space
References: <3AF2F836.110993A2@comrise.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 10
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:272
Article PK: 1060790

Which limits are you hitting?

If your database is getting full, the usual solution is to use DISK INIT to
create
new devices and ALTER DATABASE to give the database some space
on them.

-bret

Comrise wrote:

> Hi, all
>
> My sybase SQL server's Database devie space just closing the limit, how
> can I extend the space on SunOs?
>
> Thanks in Advance.
>
> Peter Sun


Comrise Posted on 2001-05-08 13:45:21.0Z
Message-ID: <3AF7F871.F3652FF2@comrise.com>
Date: Tue, 08 May 2001 09:45:21 -0400
From: Comrise <peter.sun@comrise.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Extent the sybase device space
References: <3AF2F836.110993A2@comrise.com> <3AF317EA.86830FB5@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 20
NNTP-Posting-Host: 209.191.2.117
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:271
Article PK: 1060786

Hi, Bret,

Thank you for your help.

My sybase database device was created on a independent volume, but now, the
volume space is closing to 100 percent, so, how do I use disk init to create a
new device to extend the database space in this case, and we have not another
new hardisk.

Thanks again

Peter Sun

Bret Halford wrote:

> Which limits are you hitting?
>
> If your database is getting full, the usual solution is to use DISK INIT to
> create
> new devices and ALTER DATABASE to give the database some space
> on them.
>
> -bret
>
> Comrise wrote:
>
> > Hi, all
> >
> > My sybase SQL server's Database devie space just closing the limit, how
> > can I extend the space on SunOs?
> >
> > Thanks in Advance.
> >
> > Peter Sun


Bret Halford Posted on 2001-05-10 17:03:26.0Z
Message-ID: <3AFAC9DE.B39DDE09@sybase.com>
Date: Thu, 10 May 2001 11:03:26 -0600
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.5 [en]C-CCK-MCD (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Extent the sybase device space
References: <3AF2F836.110993A2@comrise.com> <3AF317EA.86830FB5@sybase.com> <3AF7F871.F3652FF2@comrise.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 28
NNTP-Posting-Host: bret-pc.sybase.com 157.133.80.211
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:265
Article PK: 1060781

If you don't have any more physical space left on the hard drives (either as raw
partitions or
in a file system), then I think your only option would be to buy some more discs.
DISK INIT
cannot create space out of thin air!

-bret

Comrise wrote:

> Hi, Bret,
>
> Thank you for your help.
>
> My sybase database device was created on a independent volume, but now, the
> volume space is closing to 100 percent, so, how do I use disk init to create a
> new device to extend the database space in this case, and we have not another
> new hardisk.
>
> Thanks again
>
> Peter Sun
>
> Bret Halford wrote:
>
> > Which limits are you hitting?
> >
> > If your database is getting full, the usual solution is to use DISK INIT to
> > create
> > new devices and ALTER DATABASE to give the database some space
> > on them.
> >
> > -bret
> >
> > Comrise wrote:
> >
> > > Hi, all
> > >
> > > My sybase SQL server's Database devie space just closing the limit, how
> > > can I extend the space on SunOs?
> > >
> > > Thanks in Advance.
> > >
> > > Peter Sun


Pratap Posted on 2001-05-22 20:34:47.0Z
From: Pratap
Date: Tue, 22 May 2001 16:34:47 -0400
Newsgroups: sybase.public.sqlserver.backup+recovery
Subject: Re: Extent the sybase device space
Message-ID: <76CC96F142136AD700710C6185256A54.0060A44B85256A48@webforums>
References: <3AF2F836.110993A2@comrise.com> <3AF317EA.86830FB5@sybase.com> <3AF7F871.F3652FF2@comrise.com> <3AFAC9DE.B39DDE09@sybase.com>
Lines: 6
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: 7bit
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com!webforums.sybase.com!news
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:234
Article PK: 1060753

If you want to create some space for time being, take the data out of some
least used tables (old data) thru BCP or in some other fashion and delete
those records from those tables. you get some space for the database.
Meanwhile, get some new hard disk and do the disk initialization and alter
the database

Pratap


Comrise Posted on 2001-05-10 19:37:10.0Z
Message-ID: <3AFAEDE6.29207B68@comrise.com>
Date: Thu, 10 May 2001 15:37:10 -0400
From: Comrise <peter.sun@comrise.com>
X-Mailer: Mozilla 4.72 [en] (Windows NT 5.0; I)
X-Accept-Language: en
MIME-Version: 1.0
Subject: Re: Extent the sybase device space
References: <3AF2F836.110993A2@comrise.com> <3AF317EA.86830FB5@sybase.com> <3AF7F871.F3652FF2@comrise.com> <3AFAC9DE.B39DDE09@sybase.com>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
Newsgroups: sybase.public.sqlserver.backup+recovery
Lines: 31
NNTP-Posting-Host: 209.191.2.117
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.backup+recovery:264
Article PK: 1060783

Thanks a lot.

Peter Sun

Bret Halford wrote:

> If you don't have any more physical space left on the hard drives (either as raw
> partitions or
> in a file system), then I think your only option would be to buy some more discs.
> DISK INIT
> cannot create space out of thin air!
>
> -bret
>
> Comrise wrote:
>
> > Hi, Bret,
> >
> > Thank you for your help.
> >
> > My sybase database device was created on a independent volume, but now, the
> > volume space is closing to 100 percent, so, how do I use disk init to create a
> > new device to extend the database space in this case, and we have not another
> > new hardisk.
> >
> > Thanks again
> >
> > Peter Sun
> >
> > Bret Halford wrote:
> >
> > > Which limits are you hitting?
> > >
> > > If your database is getting full, the usual solution is to use DISK INIT to
> > > create
> > > new devices and ALTER DATABASE to give the database some space
> > > on them.
> > >
> > > -bret
> > >
> > > Comrise wrote:
> > >
> > > > Hi, all
> > > >
> > > > My sybase SQL server's Database devie space just closing the limit, how
> > > > can I extend the space on SunOs?
> > > >
> > > > Thanks in Advance.
> > > >
> > > > Peter Sun