恢复被使用数据库

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