I have a backed up database that I want to restore onto another server. Using Enterprise Manager with SQL Server 2000, I have followed these steps:
Click Tools
Click Restore Database
Click Restore from Device
Click Select device
Click Add
Click Navigation button next to file name
I get a box labelled Backup Device Location (local) and I'm unable to navigate to a network drive. I mapped a drive on the server I want to restore to that points to the location I want to restore from, but it's still unable to see the drive.
So, how can I restore a database over a network drive?
Thanks,
Cathy
Click Tools
Click Restore Database
Click Restore from Device
Click Select device
Click Add
Click Navigation button next to file name
I get a box labelled Backup Device Location (local) and I'm unable to navigate to a network drive. I mapped a drive on the server I want to restore to that points to the location I want to restore from, but it's still unable to see the drive.
So, how can I restore a database over a network drive?
Thanks,
Cathy