Get your favorite SSC scripts directly in SSMS with the free SQL Scripts addin.
Search for scripts directly from SSMS, and instantly access any saved scripts in your
SSC briefcase from the favorites tab.
Download now (direct download link)
Thank this author by sharing:
By Gene Hunter,
you have to create backups with unique filenames or the files will get overwritten, so the sql script generates that, part. then you have to create a batch job on both source and destination servers and run in a scheduled task. the first batch file copies only new backups to the remote server, usually a backup or disaster recovery server. The second scheduled batch file deletes files older than -d -7 days . so you always have 7 days of backups and transaction logs.
email if you need assistance, works great for me.
I want to allow a user to launch a batch file to do full backup
Batch Variable in sqlcmd
Server to server backup
SQL Server utilities interpret GO as a keyword to separate the batch. GO is not a Transact-SQL state...