-May-27-2025-10-14-42-1506-AM.png?width=150&height=38&name=IEGGroup-Logo_Black-filled%20(2)-May-27-2025-10-14-42-1506-AM.png){kind=logo}
T-SQL Script: Automated FULL backup (daily)
T-SQL Script: Automated FULL backup (daily), Creates dated filenames. Ensures the folder exists. Logs start/end times. Works well in SQL Agent job
DECLARE
@DB SYSNAME = 'YourDatabase',
@Path NVARCHAR(260) = 'D:\SQLBackups\',
@File NVARCHAR(400),
@TS NVARCHAR(20);
SET @TS = REPLACE(CONVERT(VARCHAR(19), GETDATE(), 120), ':', '-');
SET @File = @Path + @DB + '_FULL_' + @TS + '.bak';
PRINT 'Starting FULL backup: ' + @File;
BACKUP DATABASE @DB
TO DISK = @File
WITH INIT, COMPRESSION, STATS = 10;
PRINT 'Backup completed.';
@DB SYSNAME = 'YourDatabase',
@Path NVARCHAR(260) = 'D:\SQLBackups\',
@File NVARCHAR(400),
@TS NVARCHAR(20);
SET @TS = REPLACE(CONVERT(VARCHAR(19), GETDATE(), 120), ':', '-');
SET @File = @Path + @DB + '_FULL_' + @TS + '.bak';
PRINT 'Starting FULL backup: ' + @File;
BACKUP DATABASE @DB
TO DISK = @File
WITH INIT, COMPRESSION, STATS = 10;
PRINT 'Backup completed.';