恢复被使用数据库

use master
go
exec Sp_KillAllProcessInDB 'guagua_goods_config'
go
---以下为恢复备份时， 通过脚本生成的内容
RESTORE DATABASE [guagua_goods_config] FROM  DISK = N'C:\guaguagoods备份\guagua_goods_config_backup_2013_10_06_030006_6311039.bak' WITH  FILE = 1,  MOVE N'guagua_goods_config' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\guagua_goods_config.mdf',  MOVE N'guagua_goods_config_log' TO N'D:\Program Files\Microsoft SQL Server\MSSQL10.MSSQLSERVER\MSSQL\DATA\guagua_goods_config.ldf',  NOUNLOAD,  REPLACE,  STATS = 10
GO