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 |
|
Gili
Starting Member
42 Posts |
 Posted - 2005-08-15 : 09:42:24
|
| I am trying to restore a databse from a remote server into my test server that located on my PC.I have tried in enterprise manager by creating a device \\server\folder\filename.bakand receive "Unable to verify the existence of the backup file location. Do you want to use the backup file location anyway?". If I say yes I receive "Cannot open backup device "\\server\folder\filename.bak" Device error or device off line.what do you think is the problem...Any suggestions thanks!!! |
|
|
Kristen
Test
22859 Posts |
Posted - 2005-08-15 : 10:32:21
|
| Can you copy the backup file to the server's local disk, and restore from there?Kristen |
 |
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 10:40:02
|
| Does the sql service account have permissions over the remote folder?====================================================Regards,Sean RoussyThank you, drive through |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-08-15 : 10:40:35
|
| it's take a long time 8 GB .and i know that there is a way to restore from a remote server, i did it once but it don't work anymore. |
|
|
|
Thrasymachus
Constraint Violating Yak Guru
483 Posts |
Posted - 2005-08-15 : 10:51:03
|
| yes it is possible but the account that sql server is running under must be a windows domain account that has rights over the remote folder and that is what Kristen's and my questions were digging at.====================================================Regards,Sean RoussyThank you, drive through |
|
|
|
Gili
Starting Member
42 Posts |
Posted - 2005-08-16 : 02:17:38
|
| well the sql server is running under Local System account both on my pc and on the server. Thanks gil. |
|
|
|
JNitties
Starting Member
3 Posts |
Posted - 2005-08-17 : 11:58:35
|
| I have seen device activation errors when storing a database with a UNC path or mapped drive. I would take Kristen's advice and store it locally and use a local path.----------------------- |
|
|
|
|
|
|
Restore Database Problem