Re: Regarding Suspect Database

From: Noorali Issani (naissani_at_softhome.net)
Date: 03/22/04 

Date: Mon, 22 Mar 2004 10:04:18 +0500

Hari , One question here... can you please explain this..

2. Start the database in Emergency mode , Update the Status column in
master..sysdatabases table for that database to 32768.

Thanks
Noor

"Noorali Issani" <naissani@softhome.net> wrote in message
news:%23DqkBf8DEHA.3804@TK2MSFTNGP09.phx.gbl...
> Thanks Hari...
>
> Regards
> "Hari" <hari_prasad_k@hotmail.com> wrote in message
> news:uhke752DEHA.3696@TK2MSFTNGP10.phx.gbl...
> > Hi,
> >
> > There are various possibilities for a Suspect status
> >
> > 1. The MDF or LDF file for the database is not available during startup
> > 2. LDF file missing or Corrupted
> > 3. MDF file page allocation problems.
> >
> > 1. The first one can be resolved by executing "sp_resetstatus" stored
> > procedure and restart SQL server services
> > 2. Start the database in Emergency mode , Update the Status column in
> > master..sysdatabases table for that database to 32768.
> > After this database will be usable with out transaction log. AFter
this
> > create a new database and use DTS to transfer objects and data.
> >
> > 3. Third one is critical , try executing DBCC CHECKDB with
REPAIR_REBUILD
> > option. If the problem is not rectified
> > wither restore from Backup or contact Microsoft support.
> >
> > Thanks
> > Hari
> > MCDBA
> >
> >
> >
> >
> >
> > "Noor" <anonymous@discussions.microsoft.com> wrote in message
> > news:3CAC7A08-1F9A-433A-83E3-CE5DD8A597FC@microsoft.com...
> > > Can any body let me know about the suspect database what is the
remedies
> >
> >
>
>

Relevant Pages

  • Re: Check database healthiness on a daily basis?
    ... > Thanks so much for your instance response, Hari. ... DBCC CHECKDB will run for a long time if your database is ... >> Monthly once check the fragmentation of table using DBCC ... >> THis will remove the fragmentation and increase the performance. ...
    (microsoft.public.sqlserver.server)
  • Re: Regarding Suspect Database
    ... database is Suspect - Emergency Mode, ... Thanks Hari, ... >> marks a database suspect and the automatic recovery will fail. ...
    (microsoft.public.sqlserver.clients)
  • Re: is it possible to move table(s) from one db to another?
    ... Well Hari. ... > It seems tin needs to move the table from one database to another ... Script out all the data using available third party tools and script ... >> Vinod Kumar ...
    (microsoft.public.sqlserver.server)
  • Re: SQL 2000 and NTFS
    ... who gains access to the file can reattach the database ... Shouldn't there be a warning that NTFS permissions should ... >I thought the problem was inside SQL Server. ... >Hari Prasad. ...
    (microsoft.public.sqlserver.security)
  • Re: Can you hide a database structure?
    ... along with SQL DE. ... Anyone with admin rights on the machine will be able to ... "Hari Prasad" wrote: ... > Do not give access to that database to any users. ...
    (microsoft.public.sqlserver.msde)