Util script para restaurar una base de datos en SQL SERVER 2008

ALTER DATABASE [MYDATABASENAME] SET SINGLE_USER WITH ROLLBACK IMMEDIATE RESTORE DATABASE [MYDATABASENAME] FROM DISK = N'C:\DBD.bak' WITH replace GO