MS Sql Backup, Restore script

SqlBackupToRestoreFromFile

=========== BACKUP
USE master;
BACKUP DATABASE [Ecp] 
TO  DISK = N'C:\dbbackups\ecp.Bak' WITH NOFORMAT, NOINIT,  
NAME = N'Ecp-Full Database Backup', SKIP, NOREWIND, NOUNLOAD,  STATS = 10

=========== RESTORE
USE master;
ALTER DATABASE [Ecp] SET OFFLINE WITH
ROLLBACK IMMEDIATE
GO

RESTORE DATABASE [Ecp] 
FILE = N'Ecp' FROM  DISK = N'C:\dbbackups\ecp.Bak' WITH  FILE = 1,  
NOUNLOAD,  REPLACE,  STATS = 10
GO

ALTER DATABASE [Ecp] SET ONLINE
GO