Restore DB

USE [master]
ALTER DATABASE [Intranet359] SET SINGLE_USER WITH ROLLBACK IMMEDIATE
RESTORE DATABASE [Intranet359] FROM  DISK = N'D:\Data\intranet.bak' WITH  FILE = 1,  
MOVE N'Intranet' TO N'D:\DATA\Intranet359.mdf',  
MOVE N'Intranet_log' TO N'D:\DATA\Intranet359_log.ldf',  
NOUNLOAD,  REPLACE,  STATS = 5
ALTER DATABASE [Intranet359] SET MULTI_USER
GO