:: SQL Database in Suspect Mode

Hi,
I have a SQL Server 2000 , SP2 ... and last night something hapen, I have
restore a database from an Aplication an I get
some error messages on Event Viewer and database remain in Suspect
(Mode) ... and I can't access the database ! The phisical files (.mdf and
.ldf )of the database are there on the disk .
Can I recover my database in some way !?
______________________________________________
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 31.12.2003
Time: 19:37:09
User: NT AUTHORITY\SYSTEM
Computer: D53
Description:
Error: 9004, Severity: 23, State: 2
An error occurred while processing the log for database 'myDatabaseDB'.
______________________________________________________
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 31.12.2003
Time: 19:37:09
User: NT AUTHORITY\SYSTEM
Computer: D53
Description:
Error: 3314, Severity: 21, State: 4
Error while undoing logged operation in database 'myDatabaseDB'. Error at
log record ID (728:2465:143).
____________________________________________________________________________
__
Event Type: Error
Event Source: MSSQLSERVER
Event Category: (2)
Event ID: 17052
Date: 31.12.2003
Time: 19:37:09
User: NT AUTHORITY\SYSTEM
Computer: D53
Description:
Error: 9001, Severity: 21, State: 1
The log for database 'myDatabaseDB' is not available.
--
Miron Ovidiu
_________________________________
Transilvania General Import Export
Departament IT
Phone: 0259-407267
Mobile: 0722-231477Check Resetting the Suspect Status in books online
>--Original Message--
>Hi,
>I have a SQL Server 2000 , SP2 ... and last night
something hapen, I have
>restore a database from an Aplication an I get
>some error messages on Event Viewer and database remain
in Suspect
>(Mode) ... and I can't access the database ! The
phisical files (.mdf and
>..ldf )of the database are there on the disk .
>Can I recover my database in some way !?
>______________________________________________
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 31.12.2003
>Time: 19:37:09
>User: NT AUTHORITY\SYSTEM
>Computer: D53
>Description:
>Error: 9004, Severity: 23, State: 2
>An error occurred while processing the log for
database 'myDatabaseDB'.
>______________________________________________________
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 31.12.2003
>Time: 19:37:09
>User: NT AUTHORITY\SYSTEM
>Computer: D53
>Description:
>Error: 3314, Severity: 21, State: 4
>Error while undoing logged operation in
database 'myDatabaseDB'. Error at
>log record ID (728:2465:143).
>__________________________________________________________
__________________
>__
>Event Type: Error
>Event Source: MSSQLSERVER
>Event Category: (2)
>Event ID: 17052
>Date: 31.12.2003
>Time: 19:37:09
>User: NT AUTHORITY\SYSTEM
>Computer: D53
>Description:
>Error: 9001, Severity: 21, State: 1
>The log for database 'myDatabaseDB' is not available.
>
>--
>Miron Ovidiu
>_________________________________
>Transilvania General Import Export
>Departament IT
>Phone: 0259-407267
>Mobile: 0722-231477
>
>.
>|||HI,
Please try the system procedure,
sp_resetstatus <dbname>
After this restart SQL Server.
Thanks
Hari
MCDBA
"Miron Ovidiu" <webmaster@.europeandrinks.ro> wrote in message
news:OQP4i#b1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a SQL Server 2000 , SP2 ... and last night something hapen, I have
> restore a database from an Aplication an I get
> some error messages on Event Viewer and database remain in Suspect
> (Mode) ... and I can't access the database ! The phisical files (.mdf
and
> .ldf )of the database are there on the disk .
> Can I recover my database in some way !?
> ______________________________________________
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 9004, Severity: 23, State: 2
> An error occurred while processing the log for database 'myDatabaseDB'.
> ______________________________________________________
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 3314, Severity: 21, State: 4
> Error while undoing logged operation in database 'myDatabaseDB'. Error at
> log record ID (728:2465:143).
>
____________________________________________________________________________
> __
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 9001, Severity: 21, State: 1
> The log for database 'myDatabaseDB' is not available.
>
> --
> Miron Ovidiu
> _________________________________
> Transilvania General Import Export
> Departament IT
> Phone: 0259-407267
> Mobile: 0722-231477
>
>|||I had a simmilar issue with a 300GB database :( Resetting the didn't fix it,
the recovery failed at the same point when sqlservr was restarted. I had to
restore from tape backup.
But it might work for you.
"Miron Ovidiu" <webmaster@.europeandrinks.ro> wrote in message
news:OQP4i%23b1DHA.2680@.TK2MSFTNGP11.phx.gbl...
> Hi,
> I have a SQL Server 2000 , SP2 ... and last night something hapen, I have
> restore a database from an Aplication an I get
> some error messages on Event Viewer and database remain in Suspect
> (Mode) ... and I can't access the database ! The phisical files (.mdf
and
> .ldf )of the database are there on the disk .
> Can I recover my database in some way !?
> ______________________________________________
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 9004, Severity: 23, State: 2
> An error occurred while processing the log for database 'myDatabaseDB'.
> ______________________________________________________
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 3314, Severity: 21, State: 4
> Error while undoing logged operation in database 'myDatabaseDB'. Error at
> log record ID (728:2465:143).
>
____________________________________________________________________________
> __
> Event Type: Error
> Event Source: MSSQLSERVER
> Event Category: (2)
> Event ID: 17052
> Date: 31.12.2003
> Time: 19:37:09
> User: NT AUTHORITY\SYSTEM
> Computer: D53
> Description:
> Error: 9001, Severity: 21, State: 1
> The log for database 'myDatabaseDB' is not available.
>
> --
> Miron Ovidiu
> _________________________________
> Transilvania General Import Export
> Departament IT
> Phone: 0259-407267
> Mobile: 0722-231477
>
>