Brian Thor
asked on
SQL Server Maintenance Plan backup to NAS
I have setup a maintenance plan which is currently backing up to the local hard drive of the SQL Server. I would like to have the BAK and TRN files go directly to a local NAS device. The problem is that the NAS requires authentication and I don't know how to configure that in the maintenance plan. Is this possible and if so, how?
ASKER
I should have explained that the NAS is not domain joined. Is there a way to provide credentials other than letting SQL use it's own service account?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
1. UNC path
Give the backup destination path as \\ServerName\ShareName2. Drive map
Map a drive to the NAS share and give the backup destination path as DriveLetter:\