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.