UNSOLVED
B
brunofernandez
6 Posts
0
2624
August 29th, 2016 06:00
Avamar 7.2 with MSSQL Plugin
Hi there
We have installed a new enviroment with Avamar 7.2.
Actually I'm checking out all possibilities and plugins to back up our SQL cluster systems.
In our old Avamar enviroment we had already the MSSQL plugin in use but now there is a new option in the wizard.
First you have to select a var directory who has to be locally. Then you have to select a sysdir directory who has to be a UNC path.
For what is this sysdir share needed? with older versions of avamar we hadn't to give a UNC path.
Can somebody explain me for what this sysdir directory is?
As I remember the var directory is for logs and some config files. but the sysdir?
In the Avamar SQL Server user guide I havn't found anything.
Thanks and regards
Bruno
998
0
Posted August 30th, 2016 06:00
Thanks for your help Karl butut our databases are located on CSV over SAN and no VHD's.
998
0
Posted August 31st, 2016 08:00
Sys dir is required with SQL running on Microsoft Windows Server 2012 R2. You would need to give a UNC path for shared folder.
Below is the extract from SQL user Guide.
Type the name of the client's SYSDIR directory, using UNC format, in the Cluster
client’s SYSDIR directory box, or click Browse to select a shared network folder or
volume.
The SYSDIR directory must have greater than 2 GB of available space.
998
0
Posted August 31st, 2016 23:00
Thank you for the Reply but FOR WHAT is this sysdir? Why is it needed.
In a MSSQL Cluster you already have shared disks so for what do you even need a share?
998
0
Posted September 1st, 2016 13:00
As mentioned before, SQL2012 supports shared VHDX files on an SMB mount. Avamar is allowing you to put in that same information, if you're using them for your SQL instance. If not, you should be able to skip that field. Is this not the case?
998
0
Posted September 5th, 2016 04:00
no it isn't. The sysdir ist mandatory as I said in the first post
998
0
Posted October 3rd, 2016 09:00
no more hints out there?
998
0
Posted November 15th, 2016 13:00
Not sure if you got your answer, I also ran into the problem. So instead of using the new cluster configuration to create the SQL cluster, I used the old cluster configuration executable to create it.
Go to your primary SQL cluster server, and head to C:\program files\avs\bin instead of running "av_cluster_config_wizard.exe" use the old executable which is "AvamarClusterConfiguration.exe"I was able to set it up without the sysdir.
umichklewis
4 Apprentice
•
1190 Posts
998
1
Posted August 29th, 2016 08:00
Take a look at page 18 of the Avamar SQL guide. If your SQL servers are Windows 2012 R2 or later, this might apply to you:
On Windows Server 2012 R2, the Avamar Plug-in for SQL Server supports storage of SQL Server databases and log files in an active/passive cluster on shared disks, clustered shared volumes (CSVs), and shared virtual hard disk (VHDX) files. Shared VHDX files must be located on either a CSV or on a Server Message Block (SMB) 3.0 file share.
I suspect it's asking for a path for any Shared VHDX files where your databases and logs could be stored.
Let us know if that helps!
Karl