Unsolved
2 Posts
0
397
September 24th, 2020 13:00
How do you backup your SQL? Powershell Scripts? Replay manager, What backup software?
This might be long, but this is a battle i have been facing for years now. We are SC9000 compellent shop. We have LARGE, high volume SQL servers that are connected to VMware via RDM. We ONLY use RDM because we use dell replay manager software to initiate consistent SQL snapshots on the san. Being an RDM, there are no backup solutions that can back up this data separately.
Veeam has a plugin, and can take the SQL VSS snapshots on the SAN, BUT, it must be VMDK and veeam cannot do a snapshot of the SQL to the san WHILE a backup is being performed. So if our backup takes 10hrs, no SAN snapshots for 10 hours. this doesnt work for us.
What are you guys doing in this case for snapshots and backups to keep consistent SQL data? I have heard some people using replay manager for the snapshots, then creates a powershell script to create a view volume, mount it, and backup that view. Has anyone done this? That would work for me, i need something automated that goes every night.
Anyone?
briansawyer-koc-pa.com
2 Posts
0
September 25th, 2020 05:00
We are in the same situation. Our backup software, Quest Rapid Recovery will not backup RDM's either. In addition to relying on Compellent Volume snapshots- we replicate those same volumes to our offsite DR location. But we have also found real value in making SQL flat files backups on our SQL servers that have the RDMs, and then running a scheduled task to copy those flat file backups to a server that can be backed up by Rapid Recovery. We then run another task on the destination server to purge those SQL flat file backups daily to make room for the next day's flat file copy. Until RDMs can be backed up, we'll have to rely on these methods. Hope this helps.
Brian