Thanks for the tip, that won't work in this case. It's a 2005 server and I am wanting to make a copy of a backup in the filesystem after the backup completes.
I need to copy some files as a part of a SQL backup job.
I've been looking all over for Microsoft's recommended approach and don't see an indication as to what is the safest:
1. enabling xmp_cmdshell
2. enabling Ole Automation Procedures
3. enabling clr
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.