How to restore the accidentally deleted data in the Enterprise Manager of the ms SQL database

Use the following tool to restore the deleted database files (*. MDF, *. LDF)

**************************************** **********************************
Note that any disk operations, including software installation, may damage the deleted files and cause file recovery to fail.

Therefore, we recommend that you install the above file recovery tool on another computer.
And mount your hard disk to the computer for file recovery.
**************************************** **********************************
========================================================== ==================================
File Recovery Tools

Easyrecovery
Download: http://www.skycn.com/soft/13950.html

An excellent data recovery tool can rescue hard drive data that has been damaged, formatted, and deleted by viruses!
Version 6.0 uses the new data recovery engine, and is able to access ZIP files and Microsoft's office series
Document repair! Ontrack data advisor is also included in 6.0! For other updates, see the software.
Built-in readme

Finaldata NNT standard 1.5

Finaldata can recycle files accidentally deleted in Windows NT/2000/XP.
It can also restore your data, Master Boot records (MBR), boot sectors, and fat.
It can retrieve the information that other similar tools cannot find, which is safe, fast, and professional.

Acronis recoveryexpert 2003
Download: http://www.91now.com/downsky/soft/7175.htm

Acronis recoveryexpert is a data recovery software that is powerful and can even restore deleted
Hard Disk Partition! If your system is damaged, the software allows you to recover data by starting a CD.
It can protect you from data loss caused by errors of other software, viruses, and even hacker tools.

========================================================== ======================================

Use the following method to attach a database:

Enterprise Manager
-- Right-click "Database"
-- All tasks
-- Attach a database
-- Select your. MDF file name
-- OK
-- If no. LDF file is displayed and whether to create it, select "yes"

Query the method in Analyzer:
-- Data files and log files
Sp_attach_db 'database name'
, 'Data file name (*. MDF must contain a directory) '-- multiple data files in the database can be separated by commas (,).
, 'Log file name (*. LDF must contain a directory) '-- multiple log files of the database can be separated by commas (,).

-- If only data files exist
Sp_attach_single_file_db 'database name'
, 'Data file name (*. MDF must contain a directory) '-- multiple data files in the database can be separated by commas (,).