Declare @DataBaseName as nvarchar(50) Declare @BackupPath as nvarchar(100) Set @DataBaseName = 'DataBaseName' Set @BackupPath = 'C:\Home\DataBase\backup\Database.bak' BACKUP DATABASE @DataBaseName TO DISK = @BackupPath WITH NOFORMAT, NOINIT,SKIP, NOREWIND, NOUNLOAD, STATS = 10