------ Author: Endless Sky 2004.10.18 The first step: using software to restore the database and log files Software Description: Active @ UNDELETE is a powerful Undelete software, you can recover accidentally deleted files and data Even if the file is damaged, it can save the data. It is characterized by using a simple, guided interface, and is quite powerful, and the "simple" "Advanced" "low" three modes can be implemented, and the maximum recovery of your data. You can also create a partition as a disk image, avoiding the deleted data overlays due to disk operations. Even virtual disk is used as a virtual RAID volume. After my experiment, you can find the deleted files that Recover4all and Search and Recover, you can find and recovery with Active @ Undelete, and the scanning speed is also faster. It is also possible to restore data from NTFS partitions under Win98 ~~ Recommended users with higher data security requirements.
Download address: http://soft.jetdown.com/soft/53317.htm
This is a Chinese version:
Action: Use the above software to restore the MDF and LDF files of the database.
Step 2: / Additional Database // Method 1: Open Enterprise Manager -> Right click on Database -> All Tasks -> Additional Database ...-> Select the corresponding MDF file -> Complete
Method 2: In the query analyzer. sp_attach_db 'Database Name,' Path plus MDF file name, 'path plus LDF file name'
- Only the case of the MDF file sp_attach_single_file_db 'database name', 'path plus MDF file name'
See the online documentation for details.
Take a database separation here: Remove the logical database only in DBSM, but the database files and logs still exist. Separate Database / Method 1: Open Enterprise Manager -> Right click on the appropriate database -> All tasks -> Separate the database ..-> To ensure that there is no connection to the database -> OK
Method 2: Exec sp_detach_db 'Database Name', 'True' - Skip Update Statistics for True - With Update Statistics for False, used to move to read-only media
