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?
Brian ThorPresidentAsked:
Who is Participating?

[Webinar] Streamline your web hosting managementRegister Today

x
 
Vitor MontalvãoConnect With a Mentor MSSQL Senior EngineerCommented:
If you are going to run a database backup it should be made in a SQL Server login context.
You can try with \\IpAddress\ShareName but then you need to give permissions to public that isn't recommended by security reasons.
0
 
Vitor MontalvãoMSSQL Senior EngineerCommented:
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:\
0
 
Brian ThorPresidentAuthor Commented:
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?
0
All Courses

From novice to tech pro — start learning today.