Solved

Setup DB Backup to a network share or SAN in Microsoft SQL Server 2008 R2

Posted on 2015-01-23
2
48 Views
Last Modified: 2015-03-11
I need guidance and assistance in setting up the initial full back up followed by differential backups to a SAN or Network share of our MSSQL data. Its currently stored only locally and backed up to tape daily.

Thanks.
0
Comment
Question by:jness00
2 Comments
 
LVL 77

Expert Comment

by:arnold
ID: 40567836
Sql server management studio is the tool to use, maintenance plans.



Network Shares, would mean you have to create a backup device.
A better approach with a SAN is to have the SAN allocate another LUN that will be seen as another local drive ono which using SSMS and maintenance plan to configure the backup plan as well as transaction log backups on a schedule.

Presumably the databases reside on Lun allocated by the SAN as well.
0
 
LVL 24

Accepted Solution

by:
DBAduck - Ben Miller earned 500 total points
ID: 40568899
You can use the scripts at http://ola.hallengren.com. When you run the initial scripts just create a database before for the operations of these and then change the database name in the front of the script.

This will create jobs that run full, diff, log backups all you have to do is schedule them and then configure where you want the backup files to go.

Just remember that if you choose a Share to back up to then you will need to ensure that the SQL Server service account has permissions to the share to read/write (or simply Change/Modify) to the share folder. Backups are always done by the SQL Server Service account.
0

Featured Post

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

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

Suggested Solutions

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Viewers will learn how the fundamental information of how to create a table.
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…

770 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