Groups | Blog | Home
all groups > sql server (microsoft) > february 2007 >

sql server (microsoft) : unable to specify UNC path for restore through GUI??


KR
2/23/2007 4:31:08 PM
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
PiNiO
2/24/2007 1:23:44 PM

KR napisał(a):
[quoted text, click to view]

By default, you cannot create a database file on a mapped or UNC network
location under SQL Server 2000/2005. You can get around this by turning
on trace flag 1807.

AddThis Social Bookmark Button