If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

4.Create a new database with the same (as the suspect database has) logical name and physical *.mdf and *.ldf file names. All the *.mdf and *.ldf files should be located in exactly the same locations (directories) as the suspect database;

5.Stop SQL Server services;

6.Replace a valid *.mdf file with suspected one (created on step 1 and 2);

12.Make sure a database (you trying to recover) visible in SQL Server Enterprise Manager console (having Emergency mode?status). After doing this, you can enter the database and SELECT the data or use BCP to get it out. You may encounter errors while doing this, but in most cases much of the data can be retrieved;