restore over network problem

[ersatz]

Hello,

I am not able to restore my database. The backup file is on one server and the database is on another.

When I click on: restore database/from devices/select devices/device name I find just C: and D: drives, I don’t find the drive that I mapped. If I try to write \\server_name\d$\ SQLDATA\MSSQL\BACKUP\nwind_177 it doesn’t work, I have:
d:\\server_name\d$\ SQLDATA\MSSQL\BACKUP\nwind_177 witch give me an error.
Error: Backup device '\\server_name\d$\SQLDATA\MSSQL\BACKUP\nwind_177' failed to open. Operating system error = 2(error not found).

I work with sql server 2000 on win2003 operating system and I use the same account for both servers.

Any help would be appreciated
Thanks a lot,
ersatz

 

[mrdenny]

SQL Server will not show you mapped drives in the gui.

Make sure that the account you are using has admin rights to the server with the backup (you are trying to go through an admin share which only administrators can access).

I think that you are just getting a file not found error. Ensure that the file exists and that the path is correct. You didn't enclude the file extention in your example, make sure that you include that if there is one.

Try browsing to that path from another machine, to ensure that it exists and is working correctly.

Denny

--Anything is possible. All it takes is a little research. (Me)