I'm trying to use the Microsoft.SqlServer.Management.Smo class to connect to a remote SQL Server, perform a backup and save it to my local drive.
I currently can only connect to a remote SQL Server and backup and save the backup file to the remote SQL Server drives. The same happens when I connect to a local instance of SQL Server and backup a file, I can only save it to my local drive.
Is there a way to specify to the Microsoft.SqlServer.Management.Smo to save to the [local] or [remote] machines?
For more about Microsoft.SqlServer.Management.Smo, check out my other thread at
View Complete Post