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.

Taking a previously suspect database online without a restart.

4 posts in Product Futures Discussion Last posting was on 2005-04-27 22:38:24.0Z
Richard Posted on 2005-04-22 12:25:35.0Z
From: Richard <richard_hillstrom@spray.se>
User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206)
X-Accept-Language: en-us, en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Taking a previously suspect database online without a restart.
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Original-NNTP-Posting-Host: fsto13.se.atosorigin.com
Message-ID: <4268ed3a$1@forums-2-dub>
X-Original-Trace: 22 Apr 2005 05:25:30 -0800, fsto13.se.atosorigin.com
Lines: 8
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 22 Apr 2005 05:25:32 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 22 Apr 2005 05:25:35 -0700
X-Trace: forums-1-dub 1114172735 10.22.108.75 (22 Apr 2005 05:25:35 -0700)
X-Original-Trace: 22 Apr 2005 05:25:35 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1733
Article PK: 96682

I really miss that, happened twice this week that a so-called admin
screws up a database device so a couple of databases get marked suspect
at start. After fixing the problem and resetting the suspect flag I have
to restart Sybase. Don't want that, being able to just activate the
devices and onlining the databases would earn Sybase some points with
the PHB's.

//Richard


Bret Halford Posted on 2005-04-22 17:56:36.0Z
Message-ID: <42693AD3.C66AA4FA@sybase.com>
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Taking a previously suspect database online without a restart.
References: <4268ed3a$1@forums-2-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: bret-xp.sybase.com
X-Original-NNTP-Posting-Host: bret-xp.sybase.com
Date: 22 Apr 2005 10:56:36 -0700
X-Trace: forums-1-dub 1114192596 10.21.37.178 (22 Apr 2005 10:56:36 -0700)
X-Original-Trace: 22 Apr 2005 10:56:36 -0700, bret-xp.sybase.com
Lines: 18
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1734
Article PK: 96683

The problem, I think, comes down to activating the devices. There
is a dbcc dbrecover command that can be used in some cases, but
I believe the devices would have to be active.

-bret

Richard wrote:

> I really miss that, happened twice this week that a so-called admin
> screws up a database device so a couple of databases get marked suspect
> at start. After fixing the problem and resetting the suspect flag I have
> to restart Sybase. Don't want that, being able to just activate the
> devices and onlining the databases would earn Sybase some points with
> the PHB's.
>
> //Richard


manoj Posted on 2005-04-25 07:35:37.0Z
Reply-To: "manoj" <manoj_kumar@non.agilent.com>
From: "manoj" <manoj_kumar@non.agilent.com>
Newsgroups: sybase.public.ase.product_futures_discussion
References: <4268ed3a$1@forums-2-dub> <42693AD3.C66AA4FA@sybase.com>
Subject: Re: Taking a previously suspect database online without a restart.
Lines: 26
Organization: TCS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: sngiapat1.net.asiapac.agilent.com
X-Original-NNTP-Posting-Host: sngiapat1.net.asiapac.agilent.com
Message-ID: <426c9dc9$1@forums-1-dub>
Date: 25 Apr 2005 00:35:37 -0700
X-Trace: forums-1-dub 1114414537 192.25.42.225 (25 Apr 2005 00:35:37 -0700)
X-Original-Trace: 25 Apr 2005 00:35:37 -0700, sngiapat1.net.asiapac.agilent.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1735
Article PK: 96684

Bret can we unmount first & mount it again if the version support?
regards
Manoj

"Bret Halford" <bret@sybase.com> wrote in message
news:42693AD3.C66AA4FA@sybase.com...
> The problem, I think, comes down to activating the devices. There
> is a dbcc dbrecover command that can be used in some cases, but
> I believe the devices would have to be active.
>
> -bret
>
>
> Richard wrote:
>
> > I really miss that, happened twice this week that a so-called admin
> > screws up a database device so a couple of databases get marked suspect
> > at start. After fixing the problem and resetting the suspect flag I have
> > to restart Sybase. Don't want that, being able to just activate the
> > devices and onlining the databases would earn Sybase some points with
> > the PHB's.
> >
> > //Richard
>


Bret Halford Posted on 2005-04-27 22:38:24.0Z
Message-ID: <4270145E.A8A30410@sybase.com>
From: Bret Halford <bret@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: sybase.public.ase.product_futures_discussion
Subject: Re: Taking a previously suspect database online without a restart.
References: <4268ed3a$1@forums-2-dub> <42693AD3.C66AA4FA@sybase.com> <426c9dc9$1@forums-1-dub>
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vpn-dub-084.sybase.com
X-Original-NNTP-Posting-Host: vpn-dub-084.sybase.com
Date: 27 Apr 2005 15:38:24 -0700
X-Trace: forums-1-dub 1114641504 10.22.120.84 (27 Apr 2005 15:38:24 -0700)
X-Original-Trace: 27 Apr 2005 15:38:24 -0700, vpn-dub-084.sybase.com
Lines: 30
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.product_futures_discussion:1738
Article PK: 96689

Worth trying, but not sure if the unmount will work if the devices weren't
activated to start with.

manoj wrote:

> Bret can we unmount first & mount it again if the version support?
> regards
> Manoj
>
> "Bret Halford" <bret@sybase.com> wrote in message
> news:42693AD3.C66AA4FA@sybase.com...
> > The problem, I think, comes down to activating the devices. There
> > is a dbcc dbrecover command that can be used in some cases, but
> > I believe the devices would have to be active.
> >
> > -bret
> >
> >
> > Richard wrote:
> >
> > > I really miss that, happened twice this week that a so-called admin
> > > screws up a database device so a couple of databases get marked suspect
> > > at start. After fixing the problem and resetting the suspect flag I have
> > > to restart Sybase. Don't want that, being able to just activate the
> > > devices and onlining the databases would earn Sybase some points with
> > > the PHB's.
> > >
> > > //Richard
> >