sqlserver语句还原数据库

use master
go
---声明变量
declare @dbName nvarchar(max)='数据库名';
declare @dbFullName nvarchar(max)='d:\路径.bak';
--1.1修改为单用模式
 exec(N'ALTER DATABASE '+@dbName+' SET SINGLE_USER WITH ROLLBACK IMMEDIATE');
--1.2结束链接进程
	DECLARE @kid varchar(max)  
	SET @kid=''  
	SELECT @kid=@kid+'KILL '+CAST(spid as Varchar(10))  FROM master..sysprocesses  
	WHERE dbid=DB_ID(@dbName)  ;
	EXEC(@kid) ;
--2.执行还原语句
   restore database @dbName from  disk=@dbFullName
   with replace  --覆盖现有的数据库
--3.重置数据库为多用户模式
exec(N'ALTER DATABASE '+@dbName+' SET MULTI_USER WITH ROLLBACK IMMEDIATE');



ALTER AUTHORIZATION ON SCHEMA::db_owner TO dbo; 


ALTER AUTHORIZATION ON SCHEMA::db_owner TO db_owner