阿里云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