The BACKUP Command is shown below
DECLARE @securedb varchar(255)
IF EXISTS (SELECT * FROM NWCSCMDSData.dbo.sysobjects WHERE id = object_id(N'NWCSCMDSData.[dbo].[GPSecureDatabase]') AND xtype = 'U')
BEGIN
SET @securedb = (SELECT TOP 1 GPSecureDB FROM NWCSCMDSData..GPSecureDatabase)
END
declare dblist cursor for select name from master..sysdatabases
where not name in ('tempdb','model')
open dblist
declare @dn varchar(100)
fetch next from dblist into @dn
WHILE (@@FETCH_STATUS -1)
begin
exec ('BACKUP DATABASE [' + @dn + '] to [' + @dn + 'BACK] WITH NAME=''' + @dn +' Backup'' , INIT,STATS=10')
--exec ('sp_dboption ''' + @dn + ''',''autoclose'',''false''')
fetch next from dblist into @dn
end
close dblist
deallocate dblist
end
It is run as a sql job nightly monday to friday.