当前位置: 代码迷 >> SQL >> 回复备份bak的SQL语句
  详细解决方案

回复备份bak的SQL语句

热度:16   发布时间:2016-05-05 13:57:10.0
恢复备份bak的SQL语句
restore database perfetti from disk = 'C:\perfetti\perfetti.bak'
with move 'MBL_SALES_PROD'     to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\perfetti_Data.mdf'
    ,move 'MBL_SALES_PROD_LOG' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\perfetti_Log.ldf'
  相关解决方案