Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Restore database from network drive

Status
Not open for further replies.

cathyg18

MIS
Mar 12, 2001
54
US
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

 
It's impossible to backup or restore from a network drive.
You'll have to copy the backupfiles to the destination server and restore the database locally.

Kind Regards
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top