May 24, 2016 at 1:25 am
Hi SCC community.
We have a rather large MS SQL environment (60TB)
Our core systems run on physical hardware, some on cluster environment and the so to say none core systems run on VM Ware and some on Hyper V.
We have MS SQL, 2005, 2008 R2, 2012 and 2014 (testing) with a PDW appliance in the mix but this in not included in the 60TB db size.
Currently we do full backups every 4 days, diff backups inbetween the full backups. All the Analytical and Config db's are in Simple recovery and all the others in Full recovery so these will have Tlog backups.
These we log ship to our DR site over a dedicated network.
Our Full and Diff's still get written to tape and then transported to our DR site.
We have made numerous changes to improve our sql backup times, writing to 2 backup files, writing multiple backups at a time from different servers, etc ...
Our bottle neck is writing to tape and then extracting it at our DR site.
We writing to our SAN infrastructure but on a different tier of disk to the production environment.
What solutions are there that we can use to replace our tape functionality. Writing to tape and then transporting to DR and the extracting the backups. Our databases are growing and this means our backup sizes increase and this will increase the tape write and extract times. What is out there?
MCITP: Database Administrator 2005
MCTS SQL Server 2008
MCP SQL 2012/2014
MCSA SQL Server 2012/2014
MCSE Data Management and Analytics
May 24, 2016 at 6:17 am
My immediate thought is to look to the cloud. Instead of writing to tape and physically transporting the tape, write to cloud storage (AWS or Amazon) and then download from there. I'd still roughly follow what you're doing now, complete the backup locally and then copy to the cloud. However, I'd use that instead of tape. While I'm sure the cloud transfer of that much data won't be fast, it'll probably be faster than what you have currently. You can also speed it up. Using something AZCopy for moving the file to Azure storage streams the move, making the process very fast indeed.
"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt
Author of:
SQL Server Execution Plans
SQL Server Query Performance Tuning
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply