Posted by Erland Sommarskog on 02/24/07 09:56

KR (kraman@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, esquel@sommarskog.se

Books Online for SQL Server 2005 at
http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
Books Online for SQL Server 2000 at
http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]