JOB Steps

1 BACKUP ---------------------------------------------------

Declare @FilePath varchar (1000)

Set @FilePath = 'c:\BackSQL\'

Declare @ListaIgnorar varchar (4000)
Set @ListaIgnorar = 'master;model;tempdb;msdb;'

Declare DBCursor Cursor for
Select Name from Sysdatabases Where CharIndex(Name + ';', @ListaIgnorar) <= 0

Declare @NomeDB varchar (128) 
Declare @Statement varchar (8000)

Open DBCursor
Fetch Next from DBCursor Into @NomeDB
While @@FETCH_STATUS = 0
Begin
	
	if @NomeDB<>'ECNBackOffice'
	Begin
  	Set @Statement = 'Backup Database [' + @NomeDB + '] To Disk=''' + @FilePath + 'Back_' + @NomeDB + '.bak'' With Init'
	-- Print @Statement
	Exec (@Statement)
	End
	Fetch Next from DBCursor Into @NomeDB	
End
Close DBCursor
Deallocate DBCursor

2 VERIFY ----------------------------------------------------

Declare @FilePath varchar (1000)

Set @FilePath = 'c:\BackSQL\'

Declare @ListaIgnorar varchar (4000)
Set @ListaIgnorar = 'master;model;tempdb;msdb;'

Declare DBCursor Cursor for
Select Name from Sysdatabases Where CharIndex(Name + ';', @ListaIgnorar) <= 0

Declare @NomeDB varchar (128) 
Declare @Statement varchar (8000)

Open DBCursor
Fetch Next from DBCursor Into @NomeDB
While @@FETCH_STATUS = 0
Begin
	if @NomeDB<>'ECNBackOffice'
	Begin

		Set @Statement = 'Restore VerifyOnly From Disk=''' + @FilePath + 'Back_' + @NomeDB + '.bak'''
		-- Print @Statement
		Exec (@Statement)
	End	
	Fetch Next from DBCursor Into @NomeDB	
End
Close DBCursor
Deallocate DBCursor


3 CHECKDB -----------------------------------------------------

Declare @FilePath varchar (1000)

Set @FilePath = 'c:\BackSQL\'

Declare @ListaIgnorar varchar (4000)
Set @ListaIgnorar = 'master;model;tempdb;msdb;'

Declare DBCursor Cursor for
Select Name from Sysdatabases Where CharIndex(Name + ';', @ListaIgnorar) <= 0

Declare @NomeDB varchar (128) 
Declare @Statement varchar (8000)

Open DBCursor
Fetch Next from DBCursor Into @NomeDB
While @@FETCH_STATUS = 0
Begin
	
	
	Set @Statement = 'dbcc checkdb([' + @NomeDB + '])'
	-- Print @Statement
	Exec (@Statement)
	
	Fetch Next from DBCursor Into @NomeDB	
End
Close DBCursor
Deallocate DBCursor