Tag: jobs

SQL SERVER AUTOMATED BACKUP SETUP

Hello Everyone in this post we are going to cover how you can set automated backup functionality in a Microsoft SQL Server with Quick and Easy Steps. Create Stored Procedure Create Backup Job and Execute Delete/Modify Jobs 1. Stored Procedure backupDB CREATE procedure [dbo].[backupDB] as begin declare @path varchar(1000); set @path=’G:\backups\backup_’+CONVERT(CHAR(10), GETDATE(), 121)+’.bak’; BACKUP DATABASE […]

Back To Top