SQL Server Backup Script

BACKUP database name to disk= ' D:\3333.bak '

---Generate file names based on time

--Assigning a SQL script to a variable
Declare @SqlBackupDataBase as nvarchar (1000)
Set @SqlBackupDataBase =n ' BACKUP DATABASE House to DISK = ' E:\DBBackup\HOUSE-' +
CONVERT (varchar (one), GETDATE (), +replace) (CONVERT (varchar (), GETDATE (), 108), ': ', ') + '. Bak '
--Backup file format: Yourdatabasename-20140626233410.bak
Print @SqlBackupDataBase-printed (omitted for easy debugging)
EXEC sp_executesql @SqlBackupDataBase--Call system stored procedure, execute SQL

SQL Server Backup Script