I have backed up a database from SERVER_1 to a network drive and then trying to do a restore from SERVER_2. I selected Restore Database > from devices, then clicked on 'add' in the Choose Restore Devices window which then takes me to Choose restore destination window, but all I can see is the C:\ drive and not my network drive.
I have mapped the network drives and in Windows Explorer I can see all the mapped network drives and even access files within them. Any help greatly appreciated.
You won't be able to see the network drives/shares, but you can still access them by typing in the UNC path names.
Like this \\anothermachine\c$\backups...
You may want to check this out:
"There are two ways of constructing a software design. One way is to make it so simple that there are obviously no deficiencies. And the other way is to make it so complicated that there are no obvious deficiencies."
"If you think it's expensive to hire a professional to do the job, wait until you hire an amateur." Red Adair.
Hall of Fame
SQL handles mapped drives very difficultly. You won't be able to see the mapped drive unless the same login was used to create it. The only way I've been able to used mapped drives is to perform the mapping from within QA via xp_cmdshell 'net use m:...'
There are other ways around it but this is the safest way for me to do it. Generally I use UNC paths (\\server\share) to write to network drives and this has given me no problems.
Viewing 4 posts - 1 through 3 (of 3 total)