Unanswered: Copying SQL Backups to network backup server
I back up my SQL Server databases to a separate disk subsystem local on my server, and I wanted to know if their was a way to copy the local backup to my network backup drive. I was thinking of using xp_cmdshell or xcopy. Which is better, and can someone included some example code to help me. Thanks in advance for the help.