Monday, April 23, 2012 7:39 AM
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
Thursday, April 26, 2012 2:15 PM
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
or shared drive
If you don't have the proper credials an need to include a login and password you can also use FTP.
Friday, April 27, 2012 6:03 AM
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
Friday, April 27, 2012 9:49 AM
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"
Friday, April 27, 2012 10:04 AM
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
- Edited by Shahzad Aamir Friday, April 27, 2012 10:05 AM
Friday, April 27, 2012 10:42 AM
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.
Friday, April 27, 2012 11:06 AM
I want to display the same attached dialog box with all drives information of remote machine as I connected remote SQL Server
Friday, April 27, 2012 12:38 PM
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
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