I create a database on a server.
I have had some problem with storage
Because I am not specialist abaout Unix I mixed some JFS and raw devices for a new database.
I have some messages as database was bindind on cache. I dont make cache.

Now I can access the database and I have no possibility to drop it.

Inside the sysdatabase table on master my database has a bad status
May somebody help me.
JCU

jean-claude.uran wrote:
> I create a database on a server.
> I have had some problem with storage
> Because I am not specialist abaout Unix I mixed some JFS and raw devices for a new database.
> I have some messages as database was bindind on cache. I dont make cache.
>
> Now I can access the database and I have no possibility to drop it.
>
> Inside the sysdatabase table on master my database has a bad status
> May somebody help me.
> JCU

Have you tried the "dbcc dbrepair (database_name, dropdb)" command?

Thank you,

Yes I tried the "dbcc dbrepair (database_name, dropdb)" command, but without
success.
I am at home, and I dont remember exactly but with this command I get an
error message.


<wkraatz@csc.com> a écrit dans le message de
news:1130771106.323551.3380@o13g2000cwo.googlegrou ps.com...
>
> jean-claude.uran wrote:
> > I create a database on a server.
> > I have had some problem with storage
> > Because I am not specialist abaout Unix I mixed some JFS and raw devices
for a new database.
> > I have some messages as database was bindind on cache. I dont make
cache.
> >
> > Now I can access the database and I have no possibility to drop it.
> >
> > Inside the sysdatabase table on master my database has a bad status
> > May somebody help me.
> > JCU
>
> Have you tried the "dbcc dbrepair (database_name, dropdb)" command?
>

We will be much more likely to be able to help you once you post the
exact actual error messages you are getting.

-bret

<bret@sybase.com> a écrit dans le message de
news:1130805739.114577.163370@g44g2000cwa.googlegr oups.com...
> We will be much more likely to be able to help you once you post the
> exact actual error messages you are getting.
>
> -bret
>

The messages and the solution

The command and the messages are:

use pegase_ece_prd
Database 'pegase_ece_prd' is unavailabble. It is being bound to a named
cache.

dbcc dbrepair (pegase_ece_prd, dropdb)

Database 'pegase_ece_prd' is not marked suspect. You cannot drop it with
DBCC

Somebody propose me this solution and it was OK

/*sp_configure 'alllow updates', 1*/

/* update sysdatabases set status = 320 where name = 'pegase_ece_prd'*/
/*shutdown with nowait*/

/* dbcc dbrepair (pegase_ece_prd, dropdb)*/


Thank you to everybody