跟分离与不分离无关. 你按照下面做:1.首先备份qs1,就以你的文件为名吧,备份成QS1_001.bak,(备份你应该会吧) 把它放在D:/PUBDATE/QS目录下.也就是生成一个模板.2.在查询分析器里,执行:USE master RESTORE FILELISTONLY FROM DISK = 'D:/PUBDATE/QS/QS1_001.bak' RESTORE DATABASE DD FROM DISK ='D:/PUBDATE/QS/QS1_001.bak' WITH MOVE 'QS1' TO 'D:/PUBDATE/QS/DD_Data.mdf',MOVE 'QS1_log' TO 'D:/PUBDATE/QS/DD_Log.ldf'
