If ⑥ has Ufdata.mdf only (database file) , ufdata.ldf (log file) can manage systematic database (Master) the Sp_attach_db of systematic memory process in will restore, specific unit process of cargo bandling: In Query Analyzer or the Osql command in Dos will come true, database of Exec Sp_attach_db ' renown ' , the catalog of file of the first physics reachs ' parameter 1(file name) ' , the catalog of file of the 2nd physics reachs ' parameter 1(file name) ' is like Exec Sp_attach_db 'ufsystem' , 'd:wF821adminufsystem.ldf' , 'd:wF821adminufsystem.mdf'
Note: ? of doubt of of crusty pancake of Song of of Meng of Quan apology needs to disconnect first the join of this physics file and database, use Sp_detach_db is syntactic: Database of Exec Sp_detach_db ' renown '
If ⑦ is to have Mdf file only (database file) , need Sp_attach_single_file_db of process of another system memory
Specific grammar is Exec Ap_attach_single_file_db 'ufsystem' , 'd:wF821adminufsystem.mdf'
⑧ Stop Sql Server Service, replace Physname By New Files And Start Sql Server Service. Actually this kind of method also can apply at the circumstance when database occurrence attaint, use Sql Server to detect actively when start the function with whether in good condition database.
Remarks:
Salary project cannot install
Problem name
Salary project cannot install
Moving environment
Previous 1 2Next