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 |
|
suarezst1984
Starting Member
16 Posts |
 Posted - 2008-12-20 : 13:35:47
|
| I am trying to back all databases to another computer. I have mapped a network drive and tried using the UNC path and mapped drive. None of these work. When I use the mapped drive I get "Cannot find the path" and when I use the UNC path I get access denied.I realized that I was using the Local System account to run SQL so I changed to Administrator but when I do that then I get the error incorrect password. To be honest I have no idea what I need to do, Iam pretty new to SQL so if you could help me if you know the answer it would be much appreciated.Also a detail description of the steps would also be appreciated. |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2008-12-20 : 13:40:18
|
| Well, you can't access by mapped drive letter anyway. Second, the LocalSystem account can only access drives directly attached to that server. You'll need to run the SQL Server service under a domain account that has permissions to the drive you're trying to back up to. It is better to create a specific account for this purpose than to use an existing user account.I'd also recommend not backing up directly to the UNC path, but rather back up to a local disk, then copy the backup file to the UNC path. Any network problems that occur during the backup could corrupt your backup file. If you don't have enough local drive space consider using a backup compression utility such as SQL LiteSpeed, or buy a new disk specifically for backups. |
 |
|
|
|
|
|
Back up (network drive)