Full Database Backup Script

Full_Database_Backup_Script

	DECLARE @BackupPath nvarchar(512) = '<Directory Path of Destination Folder>'
	DECLARE @BackupName nvarchar(512) = '<Name of Backup File>'
	DECLARE @FullBackupPath nvarchar(512) = @BackupPath + '\' + @BackupName + '.bak'
	BACKUP DATABASE <Database Name>
	TO DISK = @FullBackupPath
		WITH FORMAT,
			MEDIANAME = @BackupName,
			NAME = '<Backup Name>'
			
-- REMEMBER: Add the SQL Server user to be able to write to the destination directory
-- SQL Server user can be found by looking at the Services -> SQL Server -> Log On properties page