Search SSWUG.ORG:



DATABASES

Off-Box Copies of SQL Server Backups with RoboCopy This is an off-site link.  Please review our Terms of Service for additional information.




(Michael K. Campbell) In some ways, this post outlines a bit of what I’d call a poor man’s approach to getting copies of your backups off-box and to a secondary (or tertiary/etc.) location. And that’s because there are lots of great ways to do this in most cases, ranging from using the MIRROR TO clause (Enterprise Edition ONLY), to similar COPY TO clauses added by most 3rd party SQL Server backup utilities, along with using Windows DFS or 3rd party file backup agents and such.

Read this article...







comments powered by Disqus