Improve company productivity with a Business Account.Sign Up

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 447
  • Last Modified:

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?
0
Brian Thor
Asked:
Brian Thor
  • 2
1 Solution
 
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
 
Vitor MontalvãoMSSQL 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now