guys: It's really urgent. Can anyone give me advice on how to restore db form only .mdf file. ( .ldf file has been deleted!) I tried sp_attach_single_file_db, but there is error Server: Msg 1813, Level 16, State 1, Line 1 Could not open new database . CREATE DATABASE is aborted. Log file 'CATABASEMSSQLdatadbname_Log.LDF' does not match the primary file. It may be from a different database or the log may have been rebuilt previously. Many thanks!!! Wait online!!