Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

SQL Server SMO take back up locally from remote server

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.

like image 753
Soham Dasgupta Avatar asked Jul 26 '10 11:07

Soham Dasgupta


1 Answers

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.

like image 102
marc_s Avatar answered Oct 03 '22 01:10

marc_s