读书人

回复备份bak的SQL语句

发布时间: 2012-08-25 10:06:20 作者: rapoo

恢复备份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'

读书人网 >SQL Server

热点推荐