进入cmd控制台(在开始-运行里输cmd,回车。) osql -S -Usa -P123456 数据附加:sp_attach_single_file_db @dbname = 'ServiceDb',@physname = 'D:\DataBase\ServiceDb_Data.MDF' 数据恢复:Restore Database ServiceDb From Disk = 'D:\Service\Data\ServiceDb.dat' With Move 'ServiceDb_Data' TO 'D:\Database\ServiceDb.mdf', Move 'ServiceDb_Log' TO 'D:\Database\ServiceDb_Log.ldf'
进入cmd控制台(在开始-运行里输cmd,回车。)
osql -S -Usa -P123456 数据附加:sp_attach_single_file_db @dbname = 'ServiceDb',@physname = 'D:\DataBase\ServiceDb_Data.MDF'
数据恢复:Restore Database ServiceDb From Disk = 'D:\Service\Data\ServiceDb.dat' With Move 'ServiceDb_Data' TO 'D:\Database\ServiceDb.mdf', Move 'ServiceDb_Log' TO 'D:\Database\ServiceDb_Log.ldf'