Wednesday, May 13, 2020
ad

Trends

SQL SERVER AUTOMATED BACKUP SETUP 50

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 […]