I am trying to schedule a backup on a client's server with as little effort as possible.
I have a script:
DECLARE @pathName NVARCHAR(512)
SET @pathName = 'C:\SQL Backup\DailyBackup_' + Convert(varchar(8), GETDATE(), 112) + '.bak'
BACKUP DATABASE TestDB TO DISK = @pathName WITH NOFORMAT, NOINIT, NAME = N'db_backup', SKIP, NOREWIND, NOUNLOAD, STATS = 10
What is the easiest way to execute it without using a 3rd party program?
Thanks.
...
Go to the complete details ...