Recovery of a corrupted Database due to power failure

microsoft.public.sqlserver.tools

18 Jan 2007 3:01 AM

Hari

Hi,

Iam looking for some tools or methods to recover a corrupted mdf file (SQL
-MSDE 2000)..please help me and I have tried the following :

1. used osql to open the master database and run the DBCC checkdb with
specified database name and given the following message :

Database 'RubyDB' cannot be opened. It has been marked SUSPECT by recovery.
See the SQL Server errorlog for more information.

.... i didn't find any useful information in the error log and looked in the
msdn articles and tried to reset the status using sp_resetstatus and didn't
helped. also tried to used the update to change the suspect flag status.
didn't helped

2. also tried to detach the database using the sp_detach_db and tried to
re-attach the particular db by using :

sp_attach_db @dbname = N'RubyDB', @filename1 = N'C:\Program Files\Microsoft
SQL Server\MSSQL$RUBYMSDEINSTANCE\Data\RubyDB_Data.MDF', @filename2 =
N'C:\Program Files\Microsoft SQL
Server\MSSQL$RUBYMSDEINSTANCE\Data\RubyDB_Log.LDF' ;

An got a message :

Msg 9003, Level 20, State 6, Server ADDSV1WD67Z461\RUBYMSDEINSTANCE, Line 1
The LSN (742:208:1) passed to log scan in database 'RubyDB' is invalid.

Please help me if there are any tools to analyze the database problem (in
the .mdf file) and a way to get back the data (at least in partial)...

Thanks in advance

Hari