Destination Backup to [Remote machine Path]

Question

If I connect SQL Server of any remote machine and backup database then it will store this backup on local drive of remote machine. I want to browse local drives of remote machine for backup using C# as happening in SQL Server

Answer 1

You either have to have the remote drive as shared or run your application in admin mode.  You should be able to get to any drive using the full remote machine filename

With admin priviledges.  The dollar sign indicates you have admin priviledges

\\remoremachine\c$\temp\abc.txt

or shared drive

\\remotemachine\shareddive\abc.txt

If you don't have the proper credials an need to include a login and password you can also use FTP.

---

jdweng

Answer 2

Thanks Joel.

I guess, i cannot use shared path \\remotemachine\sharedDrive\filebackup.bak for database backup.

with dollar sign I must be sure what drive name I am typing should be exit on remote machine like \\remotemachine\f$

I want to browse remote machine drive as SQL Server doing on Backup screen

Answer 3

I firgot to suggest that you can mount the drive on your computer and then access the removte drive with x:\fullpathname.  Yo can mount the drive by going into a window explorer and using the menu tools - Map Network drive.  The SQL will work with the remote drive.

Another choice is to query using the URL "File:\\remoremachine\c$\temp\abc.txt"

---

jdweng

Answer 4

Thank you so much.

But my requirement is to show excatly same browse dialog box of Backup Database (SQL Server Management Studio) in my C# windows application

Answer 5

What do you mean by exactly the "SAME".  Are yo going to create your own custom dialog box?  If you do you can put whatever you want into the box including changing the path names so they look like the remote machine.  The  path/filenames are just strings that you can manipulate.

---

jdweng

Answer 6

I want to display the same attached dialog box with all drives information of remote machine as I connected remote SQL Server

Answer 7

I can type \\remotemachine in to the Selected Path box and get the same view you are seeing except I don't get the plus signs.  I'm not sure how to get the plus signs displayed

You can open an explore.exe application to display the data rather than using a dialog box.

See this webpage for command line options

http://support.microsoft.com/kb/314853

You can also put the URL into an Internet Explorer.  The internet explorer won't have the plus signs but will look like the GUI you posted.

URL :  \\remotemachine

---

jdweng