Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

SQL Server Maintenance Plan backup to NAS

Posted on 2015-02-10
3
Medium Priority
?
351 Views
Last Modified: 2015-06-12
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
Comment
Question by:Brian Thor
  • 2
3 Comments
 
LVL 52

Expert Comment

by:Vitor Montalvão
ID: 40602809
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
 

Author Comment

by:Brian Thor
ID: 40604691
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
 
LVL 52

Accepted Solution

by:
Vitor Montalvão earned 1500 total points
ID: 40605099
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

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Microsoft Access has a limit of 255 columns in a single table; SQL Server allows tables with over 255 columns, but reading that data is not necessarily simple.  The final solution for this task involved creating a custom text parser and then reading…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

773 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question