SQL backup to UNC path with custom file name (TSQL)
I didn’t write this from scratch. I pieced it together from a few MSDN articles and posts. Just fill in the details and execute or add to a management task to get the job done. Make sure that the SQL Server agent has access to the backup path that you …