use master;ALTER DATABASE @dbname SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE @dbname SET ONLINE WITH ROLLBACK IMMEDIATE
restore database @dbname from disk = @path
use master;ALTER DATABASE @dbname SET OFFLINE WITH ROLLBACK IMMEDIATE;ALTER DATABASE @dbname SET ONLINE WITH ROLLBACK IMMEDIATE
restore database @dbname from disk = @path