How to back up database on remote computer??
-
:(( Hi, I am trying to tell MSSQL Server running on a remote computer on LAN to back up a database on my computer. This is done through a application written in c++. The Idea is to back up the database on the computer where the server is located as well as on the computer running the app. What I did before this dual requirement was presented was create a stored procedure to backup the database which took the database name and the location to be backed up to as arguments. It works well as SQL Server backs it on the local drive specified the path. No if I send in the network address of my computer to do the same, SQL SERVER error log tells me that operating system denied permission ( which is what will be expected ). I send in a string as \\computername\driverletter$\path\filename.zip How can I modify this to include the user name and passwrod so that SQL SERVER can back it up on my computer without security problems??? I have tried net use kind of syntax but it does not help. Please help!! this is really important. Thanks In advance.