My question is straight forward, how can I program SQL SMO to take local backup, by connecting to a remote server. I want to save the bak file to a local machine which is connecting to the remote server. Also I want users with only certain privilege to be able to save backups locally.
You cannot - period. Backups of SQL Server can only be saved to a local disk - local to the SQL Server itself.
You cannot with any tricks or tools backup a remote SQL Server to your local harddisk. Just can't do it.
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With