Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
joanne
Starting Member
46 Posts |
 Posted - 2004-09-27 : 14:43:07
|
| 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 appreciatedThanks a lot,joanne |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2004-09-27 : 14:45:11
|
| Run the RESTORE DATABASE command in Query Analyzer. Make sure to logon to it with an account that has restore privileges on the database server plus read permissions on the network share.Tara |
 |
|
|
|
|
|
restore problem over network