我想把备份的数据库进行还原,bak,用鼠标右键还原后发现出了问题提示,然后改用代码还原数据库备份就好了。
数据库还原备份的代码:
RESTORE DATABASE ccflow4
FROM DISK ='F:1MyProjectCCFLOW6SQL
ewSQLccport20161116.bak'
with replace,
MOVE 'ccflow4' TO 'F:SQLExampleMSSQL10_50.SQLEXPRESSMSSQLDATAccflow4.mdf',
MOVE 'ccflow4_log' TO 'F:SQLExampleMSSQL10_50.SQLEXPRESSMSSQLDATAccflow4_log.ldf'
然后就还原上了。