vxsnap create for SQL
I try to get a VSS snapshots for SQL, but I have a problem.
This is my environment:
I have distributed 10 database on 2 volumes and the logs in another one.
E:\Database, with 5 database, size 100GB
F:\Database, with 5 database, size 100GB
J:\Logs_all_Database, with 10 logs for each database, size 50GB
I have 3 volumes for the snapshots with the same size.
If I take a snapshot for one database only this database quiesce, and get the snapshot with only one consistent database.
My point is, can i get a snapshot for all the volume with only the name of the SQL instance, and get the quiesce of all databases on that volume? or I need to separate databases in individual volumes?