When re- pack the machine, forgot the backup to just just set up the good database of robot( have some datas to have already added into) under the Sql Server, chase the C dish space

The type turned.Happily the data document MDF because this ex- machine C dish space shortage put at another place, hence start consider how to use the this document of MDF Recovery data

Database.

Sought the quite a few data, this kind of circumstance still has no, seeing the introduction sp_detach_db in the delphibbs, the sp_attach_single_file_db save

Keep the data of the process, exactly the thing that I need.Hence has been practiced to pass as follows the step recovered the database of robot finally:

1.Set up lately together a database.

2.Delete its daily record document robot_Data.LDF, don't delete the process performance of the back however.

3.Establish the data of robot for off-line.

4.Search the analytical machine in all aspects in log on with the super customer, carry out following saving process, must log on with the super customer, this is the system class to save a process

.

EXEC sp_detach_db @dbname = 'robot'
EXEC sp_attach_single_file_db @dbname = 'robot', @physname = 'E:WebDemo obot_Data.MDF'

5.Establish the data of robot as machine of link .

6.Break the database, the form came out, the data is intact