--数据库备份
backup database football to disk ='C:/test2.bak' with init
--数据库还原,连接master后关闭-还原-开启
use master
alter database football set offline with rollback immediate
restore database football from disk ='C:/test2.bak' with recovery
alter database football set online with rollback immediate