| Q. |
Is it possible to backup MS SQL to a UNC path or mapped drive?
|
A.
|
Backing up MS SQL to a UNC path or a mapped drive is possible but requires a little initial setup.
When MS SQL is backing up to a share on a LAN computer, the MS SQL service cannot run as the local system account. The local system account does not have the needed privileges to backup to network locations. You must specify a username and password for the MS SQL service.
This username and password must either be a domain user account, or must have the same username and password as the computer with the share. If the username and password specified are for a domain user account, the computer with the share must be part of the domain.
|
| |
| |
 |
|