Re: DB SUSPECT

From: Shamim (shamim.abdul@railamerica.com)
Date: 07/15/02 

From: "Shamim" <shamim.abdul@railamerica.com>
Date: Mon, 15 Jul 2002 12:54:34 -0500

So before doing dbcc rebuild_log(....), I need to backup LOG WITH
NO_TRUNCATE.
Is there anyway i can get back those missing records in one table.

Thanks
Shamim

"Tibor Karaszi" <tibor.please_reply_to_public_forum.karaszi@cornerstone.se>
wrote in message news:euhQXeBLCHA.2036@tkmsftngp09...
> You should do:
>
> BACKUP LOG dbname TO ... WITH NO_TRUNCATE
>
> The last parameter is important.
>
> --
> Tibor Karaszi, SQL Server MVP
> Archive at:
http://groups.google.com/groups?oi=djq&as_ugroup=microsoft.public.sqlserver
>
>
> "Shamim" <shamim.abdul@railamerica.com> wrote in message
news:uSkTRcBLCHA.1772@tkmsftngp09...
> > Hi All,
> > SQL SERVER 7.0
> >
> > Our server has a power-outage and when it came back one of the database
> > shows as 'SUSPECT'.
> > Looked into the ErrorLog and found it was in between a transaction log
> > backup and log file is corrupted.
> >
> > Did the following steps and database came backup with one table missing
with
> > few records.
> >
> > 1)Change SUSPECT mode to Emergency mode (Update sysdatabases...)
> > 2)dbcc rebuild_log(....)
> > 3)dbcc checkdb()
> > 4)dbcc checkalloc()
> >
> > Pls Advice with steps to take-care when database goes into SUSPECT mode
.
> >
> > Thanks
> > Shamim
> >
> >
> >
>
>

Relevant Pages

  • Re: backup log <my database> with no_log
    ... The big question is why do you do a BACKUP LOG dbname WITH NO_LOG in the ... Tibor Karaszi, SQL Server MVP ... > database> with no_log. ... > what should i do to avoid this error in the event viewer? ...
    (microsoft.public.sqlserver.programming)
  • Re: DB SUSPECT
    ... If in the case i took a BACKUP LOG dbname TO ... ... ...What should i do next to bring back my database from SUSPECT. ... > You shouldn't have used DBCC REBUILD_LOG. ... >> Is there anyway i can get back those missing records in one table. ...
    (microsoft.public.sqlserver.security)
  • Re: Still problems with space
    ... Can you tell me the File growth mentioned for Transaction log file. ... IN Enterprise manager -- Select Databases -- Right click above the database ... Backup the transaction log (Use BACKUP Log dbname to ... Shrinking the Transaction Log in SQL Server 2000 with DBCC ...
    (microsoft.public.sqlserver.server)
  • Re: Disk space usage
    ... Perfmon doesn't allow you to send emails by ... growing for the life of the database. ... and running a Backup Log with NO_LOG statement to truncate the log. ... you can specify a backup location and exclude the NO_LOG statement, ...
    (microsoft.public.sqlserver)
  • Re: Automating Backups
    ... > Here is the script. ... > I have SQL Server 2K developer. ... simple recovery model so that no backup log is allowed... ... USE msdb ...
    (microsoft.public.sqlserver.msde)