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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-07 : 10:58:01
|
| Dipen Doshi writes "I am trying to restore a database from a backup file located across a network (not residing on the local computer). I mapped to that folder in which the backup file is residing. Then when I tried to restore the database from the enterprise manager, it won't let me go to the mapped drive to select the backup file as my device. Of course, I can copy it first to the server and than try to restore it, but I can't, the drive space on the server is too little. I tried using winzip to zip it up, but it won't zip files over 2GB!! I need to restore it across the network. Any ideas will be appreciated." |
|
|
Kevin Snow
Posting Yak Master
149 Posts |
Posted - 2002-05-07 : 11:15:43
|
| If it won't allow you to browse to the file location, the account under which SQL is running probably does not have read rights to that drive.If this is the case, you may try to grant rights, or move the file to a network location that is shared to everyone.You may also try temporarily switching the account under which SQL is running to one that has rights to the Network folder. |
 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-05-07 : 11:50:24
|
| Mapped drive letters can also be the problem. Trying specifying the UNC path to the backup file, instead of the mapped drive letter. If Enterprise Manager won't let you do that, run the RESTORE command in Query Analyzer instead. |
|
|
|
|
|
|
Restore a database from a backup file