Windows Cluster Shared Volumes Support

[Dima P.]

t481,

Out of curiosity what databases you store on the cluster shared volumes? Thanks!

[Justin Sciacca]

Any Update on this? We are using Cluster Shared Volumes to host our RDS application and files. We're attempting to backup the servers, but it keeps skipping the clustered volumes. I've added them as a failover cluster, but that still skips the clustered Volumes.

[HannesK]

everything is still the same.

For the foreseeable future we will only back up shared disks / volumes. If you can put the data on normal shared volumes / shared disks instead of CSVs, then it would work.

[kaare_t]

+1 wanting support for CSV.

We are currently using MSSQL in a 2-node cluster setup, and have done some testing using VMware Vvol and CSV. Compared to "traditional" clustered disks we like the possibility of shared ownership (and access-ability) to all disks between cluster-nodes and the relatively fast switchover when the SQL-service changes node.

Agent or agentless is the same for us, but support for CSV backup would be great.

[Dima P.]

Hello kaare_t,

Unfortunately the support for CSV is not planned for the next version but we keep collecting the feedback very attentively. Thank you for updating this thread!

[MariusN]

+1 wanting support for CSV. There are way too many reasons for a backup solution should support CSVs - SQL Failover Cluster without shared nothing function to meantion one.

Also different Applications which make use of WSFC's are requiring CSVs sometimes.

[HannesK]

thanks, we are working on options for SQL

[HannesK]

as VeeamON is over now: for SQL, we will have a VDI plugin that allows native backups from SQL (management studio) directly to a Veeam repository. That way you, it is possible to back up SQL data from CSVs.

[jotge]

Hello Hannes,

That sounds interesting at first. But do I interpret this correctly...

...that a maintenance plan needs to be configured in SQL Managemenmt Studio that can address a Veeam repository as a target?

...that the SQL databases are stored as .bak (full backup) and .trn (log backup) files in the repository?

...that the files stored in the repository in this way - as with a file copy job - cannot be copied to tape with a Backup2Tape job?

...that if a restore is needed, the .bak and .trn files must first be restored from the repository to the file system before they can be restored as a database with SQL Management Studio?

[HannesK]

Hello,

1) yes. it's SQL agent jobs and the SQL admin can control everything. Which database etc (today it's "all or nothing" and the database admin has no influence)
2) no, it's in Veeam Backup format (similar like Oracle and SAP HANA backups)
3) correct, backup-to-tape does not work with plugins. file-to-tape could work, but probably complicated to restore
4) no, restore works directly from the repository. No need to copy it first to anywhere else.

Best regards,
Hannes

[jotge]

Hello,

is there any news here? Is it still only being observed or is it being worked on?

The new SQL plugin is a help but it feels a bit like a workaround with a graphical user interface. For example, I can't copy these backups to tape with a Backup To Tape job and I can't do a restore with SQL Explorer on the backup server with all the usual features.


Thank you and best regards

jan

[HannesK]

Hello,
the SQL plugin is the latest news and we plan to remove the limitations for the plugin (no timeframe yet)

Best regards,
Hannes

[JaySt]

I've got a 2-node Windows fileserver Failover cluster using a shared .vmdk setup between the nodes. Used for profile containers etc. On those shared .vmdk files, CSV disks are created and formatted as CSVFS.
Veeam agents have been installed, made cluster aware etc. but the data (shared) disks are excluded as described here / mentioned in documentation of Veeam.

What are suggestions to still provide the "next best thing" in regards to backups for this? We can do storage integration with the Nimble array beneath, but not sure if that would help.

[HannesK]

Hello,
NAS backup would technically work for a file server with CSVs via SMB protocol (while having license implications).

Best regards,
Hannes

[hyvokar]

Hello,
the SQL plugin is the latest news and we plan to remove the limitations for the plugin (no timeframe yet)

Best regards,
Hannes

Hi,

is there any news to this?
I'd need to backup a SQL cluster with CSVs

[HannesK]

Hello,
the SQL plugin exists December 2023 and works with CSVs.

https://helpcenter.veeam.com/docs/backu ... ml?ver=120

Best regards,
Hannes