SAP Ms sql server recover with MDF file

[Former Member]

Dear experts,

             we have only  mssql server 2000 MDF file only . (ldf file delete) how can I restore database with .mdf only.Please do needful

Thanks a lot in advance,

Regards,

Krishna

[Former Member]

There is no need to use any third party commercial tool to restore database from .mdf file. you can simply attach .mdf file without .ldf in SQL Server

Message was edited by: John Walker

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

This message was moderated.

[Former Member]

Hi,

Attach database without log file (Process automatically creates new ldf).

Regards,

Nick Loy

[Former Member]

This message was moderated.

[Former Member]

Dear Sir,

             Thanx a lot for your reply. I had proceed above steps. But my database in suspect mode. How can i solve it.

Thanks in advance.

Regards,

Krishna

[Former Member]

Can you send me step by step what have you done so far, the results, and also paste the the SQL Server logs.

[Sriram2009]

Hi Krishna

Kindly refer the Microsoft links

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/f5463989-9a8e-4814-92de-1cde8f64ca49/how-to-...

http://www.devx.com/vb2themax/Tip/18624

http://www.gerixsoft.com/blog/mssql/recovering-mssql-suspect-mode-emergency-mode-error-1813

Thanks

Sriram

[Former Member]

I really hope this is not your production database. There is no way to know what you will lose with your ldf. Gone. You may have severe inconsistancies in the SAP data. If there was a transport midway, you will have dumps. There will be no roll-forward or rollback. If you have a backup, use that as the first option. If not, well then you have nothing to lose. Try the steps in the following article about SQL 2000. I have tried it years back, you will get your DB running. Run a complete DBCC after.

http://stackoverflow.com/questions/9972554/restore-db-from-mdf-file-lost-ldf-and-db-was-not-cleanly-...

let me know if it works.

Yogesh

[Former Member]

Hi Krishna,

Have you try methods from http://botsikas.blogspot.com/2008/05/restoring-sql-2000-database-from-mdf.html or from there http://social.msdn.microsoft.com/Forums/sqlserver/en-US/223e5449-8133-4a20-b01e-746a69af0fcf/restori...

?

BR,

K.