阿裡雲sqlserver資料庫遷移本地

第一步：檢視資料檔案和日志檔案名稱。下一步用

restore filelistonly from disk='C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\kx_training.bak'  

go

第二步：

restore database kx_training from disk='C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Backup\kx_training.bak' with   replace,norecovery,stats=10,  

move 'data1' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\kx_training.mdf',  

move 'log' to 'C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\DATA\kx_training_log.ldf'  

go

第三步：（如果上一步成功，但資料庫一直處于恢複中，執行這個）

RESTORE database   kx_training with recovery