unable to specify UNC path for restore through GUI??

[KR]

Hi,

After just installing sql 2005 on our test machine, I am trying to
restore a database using a backup file on the network. However, the
specify backup diagol box allows only for browsing to a file on the
local machine - I find no way to type a UNC path to choose the backup
file from. I can do this in 2000, is it no longer an option to doit
through the GUI or am I missing something?

Thanks

KR

[Erland Sommarskog]

KR (kr****@bastyr.edu) writes:

After just installing sql 2005 on our test machine, I am trying to
restore a database using a backup file on the network. However, the
specify backup diagol box allows only for browsing to a file on the
local machine - I find no way to type a UNC path to choose the backup
file from. I can do this in 2000, is it no longer an option to doit
through the GUI or am I missing something?

It's a bit funny that it is not available. But you can always type the
RESTORE command in a query window. If you are uncertain about the
syntax, you can pick a local file in the dialog, then select the Script
option in the top of the window, and change what you get.

If you think this is important, I suggest that you go to
http://connect.microsoft.com to see if anyone else has asked for this,
and in such case vote on the suggestion. Else, submit your own suggestion.

--
Erland Sommarskog, SQL Server MVP, es****@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/pro...ads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinf...ons/books.mspx