Link to home
Start Free TrialLog in
Avatar of Brian Thor
Brian ThorFlag for United States of America

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?
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

First of all you need to create a shared folder in NAS and give read and write permissions for SQL Server service account user then you have to options in your backup plan:

1. UNC path

Give the backup destination path as \\ServerName\ShareName

2. Drive map

Map a drive to the NAS share and give the backup destination path as DriveLetter:\
Avatar of Brian Thor

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
Avatar of Vitor Montalvão
Vitor Montalvão
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial