MSSqlServer restoring a database with SQL statements (existing backup files)

DECLARE  @dbname varchar-   -database name declare  @filename varchar-  -database backup file path set @dbname = ' MyTest ' Set @filename = ' D:\MyTest.bak '--Closes an existing database connection declare @i int DECLARE cur cursor for select spid from sysprocesses where db_name ( dbid) = @dbname  Open cur fetch next from cur to @i while @ @fetch_status =0  begin   exec (' kill ' [email protected] FETCH NEXT from cur to @i  end Close cur  deallocate cur--closed database connection--restore database @dbname from [email PR Otected] with replace--Restore DATABASE complete

　　

MSSqlServer restoring a database with SQL statements (existing backup files)