February 23, 2007 at 5:02 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
February 24, 2007 at 12:34 am
Right click on databases/Restore database/Click radio button FROM FILE/Click ... button/Click Add on SPECIFY BACKUP window/
Bottom of the Locate backup window...Replace the file path with your UNC path and enter the file name...then click OK...
In GENERAL window check the check box for Restore before you click final OK...
I have tested using UNC path...it is working fine..
MohammedU
Microsoft SQL Server MVP
February 26, 2007 at 9:01 am
Yes, that worked!
Thanks much
KR
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply