FAQ: Why does Minion Backup use xp_cmdshell instead of SQL CLR? Print
Created by: Sean McCown
Modified on: Thu, Jul 12, 2018 at 10:23 AM
Using SQL CLR would also put us in the business of having to support different .NET framework versions, which would also complicate things.
Cmdshell is the best choice because it’s simple to lock down to only administrators, and it adds no extra “gotchas”. There were times when it would have been easier to use CLR, but we simply can’t require that everyone enables CLR.
Just be sure to lock down cmdshell. For instructions on this, see this article by Sean: http://www.midnightdba.com/DBARant/?p=1243
And for further reading, here is the link to one of Sean’s rants on the topic: http://www.midnightdba.com/DBARant/?p=1204
Did you find it helpful? Yes No
Send feedbackSorry we couldn't be helpful. Help us improve this article with your feedback.