如果数据库文件mdf,ldf还在就好办
sp_attach_db "dbname" ,"c:\data\xxxx.mdf","c:\data\xxxx.ldf"
"c:\data\xxxx.mdf","c:\data\xxxx.ldf分别是数据库主文件和日志文件如果你曾经备过数据库的话,备分文件还在的话这样处理restore database "dbname" from disk = "your back up file"good luck
sp_attach_db "dbname" ,"c:\data\xxxx.mdf","c:\data\xxxx.ldf"
"c:\data\xxxx.mdf","c:\data\xxxx.ldf分别是数据库主文件和日志文件如果你曾经备过数据库的话,备分文件还在的话这样处理restore database "dbname" from disk = "your back up file"good luck
这个怎么写了,我系统是装在C盘的,但备份时就放在D盘的备份文件夹里了,文件名为ZCJ,扩展名不知是什么?