Re: Regarding Suspect Database

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

Date: Mon, 22 Mar 2004 09:33:45 +0500

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

  • Error 1813 or "WHY didnt they call me earlier?"
    ... 3- copy the data file (mdf and ndf's) over the ones from ... 4- start sql server ... >The SQL Server 7.0 database on this server appear after ... >but I get an error telling me that ldf file and mdf file ...
    (microsoft.public.sqlserver.server)
  • Re: .LDF files and SharePoint Portal
    ... So when you take a backup of the database, ... I have some questions about .LDF files and Sharepoint. ... Is it safe to delete the data in the .LDF file or will it cause ...
    (microsoft.public.sharepoint.portalserver)
  • Re: Crash Recovery
    ... You can't apply an LDF file to a restored database backup. ... >> How to restore the BAK file. ...
    (microsoft.public.sqlserver.server)
  • Re: Truncate log file
    ... It seems that the source database was not detached properly. ... ask them to resend the MDF and LDF file back again. ... >> If it is a development environment you could just attach only the MDF ... >> It seems client has not shrink the LDF file. ...
    (microsoft.public.sqlserver.server)
  • Re: Humongous transaction LOG!!!
    ... Just to be clear on this, truncating the Log doesn't shrink the size of the ... it will soon need to use the same amount of space in the .ldf file & it's ... To shrink the .ldf file you can use dbcc shrinkfile. ... This is strange since the size of the backup database is about ...
    (microsoft.public.sqlserver.server)