The SnapManager schema file is distributed with the installation package. The sample configuration file provided in this topic shows the SnapManager control file settings.
Storage layout settings
The following schema depicts the storage layout settings section. You can edit the storage layout settings using an XML editor.
<?xml version="1.0" ?>
- <SMSQLCONFIG xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<HOST_NAME>SNAPMGR-19</HOST_NAME>
- <STORAGE_LAYOUT>
<MAX_DB_JOB>255</MAX_DB_JOB>
- <SQL_INSTANCES>
- <SQL_INSTANCE>
<SQL_INSTANCE_NAME>SNAPMGR-19</SQL_INSTANCE_NAME>
<SQL_INSTANCE_SNAPINFO_PATH>K:\SMSQL_SnapInfo</
SQL_INSTANCE_SNAPINFO_PATH>
<ADD_MSISIC_DEPENDENCY>false</ADD_MSISIC_DEPENDENCY>
- <DATABASES>
- <DATABASE>
<DATABASE_NAME>master</DATABASE_NAME>
- <FILE_GROUPS>
- <FILE_GROUP>
<GROUP_NAME>PRIMARY</GROUP_NAME>
- <DATABASE_FILES>
- <DATABASE_FILE>
<FILE_NAME>master</FILE_NAME>
<FILE_PATH>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA
\master.mdf</FILE_PATH>
</DATABASE_FILE>
</DATABASE_FILES>
</FILE_GROUP>
</FILE_GROUPS>
- <LOG_FILES>
<FILE_PATH>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA empdb.mdf</FILE_PATH>
<FILE_PATH>C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA emplog.ldf</FILE_PATH>
</LOG_FILE>
\DB2.mdf</FILE_PATH>
- <DB_VOLUME>
<FILE_PATH>C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA empdb.mdf</FILE_PATH>
<FILE_PATH>C:\Program Files\Microsoft SQL Server\MSSQL.2\MSSQL\DATA emplog.ldf</FILE_PATH>
</FILE_GROUPS>
The following schema depicts the notification settings section:
-<COMMON_SETTINGS>
<SUBJECT>SnapManager for SQL Server</SUBJECT>
<NOTIFY_AUTO>true</NOTIFY_AUTO>
The following schema depicts the verification settings section:
-<VERIFICATION>
-<VERIFICATION_CLIENT_SETTING>
<VERIFICATION_SERVER>SNAPMGR-19</VERIFICATION_SERVER>
<VER_SERVER_NTAUTH>true</VER_SERVER_NTAUTH>
<VER_DBCC_NOINDEX>false</VER_DBCC_NOINDEX>
<MP_DIR>C:\Program Files\NetApp\SnapManager for SQL Server
\SnapMgrMountPoint</MP_DIR>
</VERIFICATION_SERVER_SETTING>
</VERIFICATION>
Monitoring directory settings
The following schema depicts the monitoring directory settings:
- <MONITORING.>
The following schema depicts the report directory settings section:
<REPORT_DIRECTORY>C:\Program Files\NetApp\SnapManager for SQL Server
\Report</REPORT_DIRECTORY>
Backup settings
The following schema depicts the backup settings section:
-<BACKUP>
SnapMirror volumes settings
The following schema depicts the SnapMirror relationship settings section:
-<VERIFICATION_ON_DESTINATION>
The following schema depicts the schedule job settings section:
-<VERIFICATION_ON_DESTINATION>
<START_DIR>C:\Program Files\NetApp\SnapManager for SQL Server\</
START_DIR> <APPLICATION_NAME>C:\Program Files\NetApp\SnapManager for SQL Server\SMSQLJobLauncher.exe</APPLICATION_NAME>
<COMMAND>new-backup ñsvr 'SNAPMGR-19' -db 'SNAPMGR-19', '8', 'DB1', 'DB2', 'DB3', 'DB4', 'DB5', 'master', 'model', 'msdb',
'SNAPMGR-19\MARS', '3', 'master', 'model', 'msdb' -ver ñversvr 'SNAPMGR-19' -del -rtbkups 2 -lgbkafbk -noutm -uniq ñmgmt standard</
COMMAND>
<EndDay>0</EndDay>
<START_DIR>C:\Program Files\NetApp\SnapManager for SQL Server\</
START_DIR> <APPLICATION_NAME>C:\Program Files\NetApp\SnapManager for SQL Server\SMSQLJobLauncher.exe</APPLICATION_NAME>
<COMMAND>ackup ñsvr 'SNAPMGR-19' -db 'SNAPMGR-19', '8', 'DB1', 'DB2', 'DB3', 'DB4', 'DB5', 'master', 'model', 'msdb', 'SNAPMGR-19\MARS', '3', 'master', 'model', 'msdb' ver ñversvr 'SNAPMGR19' del rtbkups 2 -lgbkafbk -noutm -uniq ñmgmt standard</COMMAND>
<START_TIME>11/7/2007 1:00:00 AM</START_TIME>
<START_DIR>C:\Program Files\NetApp\SnapManager for SQL Server\</
START_DIR> <APPLICATION_NAME>C:\Program Files\NetApp\SnapManager for SQL Server\SMSQLJobLauncher.exe</APPLICATION_NAME>
<COMMAND>backup ñsvr 'SNAPMGR-19' -db 'SNAPMGR-19', '8', 'DB1', 'DB2', 'DB3', 'DB4', 'DB5', 'master', 'model', 'msdb', 'SNAPMGR-19\MARS', '3', 'master', 'model', 'msdb' ver ñversvr 'SNAPMGR19' del rtbkups 2 -lgbkafbk -noutm -uniq ñmgmt standard</COMMAND>
<START_TIME>11/11/2007 2:00:00 AM</START_TIME>
-<SQLAGENTSCHEDULES>
<START_DATE_TIME>11/5/2007 12:00:00 AM</START_DATE_TIME>
<START_TIME_OF_DAY>02:00:00</START_TIME_OF_DAY>
The following schema depicts the clone job settings section:
<?xml version="1.0"?>
<SMSQLCONFIG xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
xmlns:xsd="http://www.w3.org/2001/XMLSchema">
<HOST_NAME>W2K8R2SP1X64</HOST_NAME>
<COMMON_SETTINGS>
<SCHEDULE_JOBS>
<JOB>
<SCHEDULER>SQL Server Agent</SCHEDULER>
<JOB_NAME>CloneAutoDel__abc__09-17-2012_21-38-44</JOB_NAME>
<HOST_NAME>W2K8R2SP1X64</HOST_NAME>
<START_DIR>"C:\Program Files\NetApp\SnapManager for SQL Server\
</START_DIR>
<APPLICATION_NAME>
"C:\Program Files\NetApp\SnapManager for SQL Server \SmsqlJobLauncher.exe
</APPLICATION_NAME>
<COMMAND>delete-clone –svr 'W2K8R2SP1X64' -inst 'W2K8R2SP1X64' -d 'abc__Clone' -JobInstance 'W2K8R2SP1X64'
-ResyncCloneJob
'CloneResync__abc__09-17-2012_21-38-44'</COMMAND>
<START_TIME>9/18/2012 9:38:37 PM</START_TIME>
<SQLAGENTSCHEDULES>
<START_DATE_TIME>20120918</START_DATE_TIME>
<START_TIME_OF_DAY>213837</START_TIME_OF_DAY>
<END_DATE_TIME>99991231</END_DATE_TIME>
<END_TIME_OF_DAY>235959</END_TIME_OF_DAY>
<FREQUENCY_TYPE>OneTime</FREQUENCY_TYPE>
<FREQUENCY_INTERVAL>0</FREQUENCY_INTERVAL>
<FREQUENCY_SUBDAY_TYPE>Unknown</FREQUENCY_SUBDAY_TYPE>
<FREQUENCY_SUBDAY_INTERVAL>0</FREQUENCY_SUBDAY_INTERVAL>
<FREQUENCY_RELATIVE_INTERVAL>First</
FREQUENCY_RELATIVE_INTERVAL>
<FREQUENCY_RECURRENCE_FACTOR>0</FREQUENCY_RECURRENCE_FACTOR>
</SQLAGENTSCHEDULES>
</JOB>
<JOB>
<SCHEDULER>SQL Server Agent</SCHEDULER>
<JOB_NAME>CloneResync__abc__09-17-2012_21-38-44</JOB_NAME>
<HOST_NAME>W2K8R2SP1X64</HOST_NAME>
<START_DIR>
"C:\Program Files\NetApp\SnapManager for SQL Server\
</START_DIR>
<APPLICATION_NAME>"C:\Program Files\NetApp\SnapManager for SQL Server\SmsqlJobLauncher.exe</APPLICATION_NAME>
<COMMAND>clone-database –svr
'W2K8R2SP1X64' –inst 'W2K8R2SP1X64' -d 'abc' -tgInst 'W2K8R2SP1X64' -tgDb 'abc__Clone' -tgmpdir 'C:\Program Files\NetApp
\SnapManager for SQL
Server\SnapMgrMountPoint' -Resynchronize -ForceTerminateConnection -ver
–verInst 'W2K8R2SP1X64' -mp –mpdir 'C:\Program Files\NetApp \SnapManager for SQL
Server\SnapMgrMountPoint' -RetainShareBackups 7 –mgmt standard </COMMAND>
<START_TIME>9/18/2012 9:38:37 PM</START_TIME>
<SQLAGENTSCHEDULES>
<START_DATE_TIME>20120917</START_DATE_TIME>
<START_TIME_OF_DAY>213837</START_TIME_OF_DAY>
<END_DATE_TIME>99991231</END_DATE_TIME>
<END_TIME_OF_DAY>235959</END_TIME_OF_DAY>
<FREQUENCY_TYPE>Daily</FREQUENCY_TYPE>
<FREQUENCY_INTERVAL>1</FREQUENCY_INTERVAL>
<FREQUENCY_SUBDAY_TYPE>Hour</FREQUENCY_SUBDAY_TYPE>
<FREQUENCY_SUBDAY_INTERVAL>12</FREQUENCY_SUBDAY_INTERVAL>
<FREQUENCY_RELATIVE_INTERVAL>First</
FREQUENCY_RELATIVE_INTERVAL>
<FREQUENCY_RECURRENCE_FACTOR>0</FREQUENCY_RECURRENCE_FACTOR>
</SQLAGENTSCHEDULES>
</JOB>
</SCHEDULE_JOBS>
</COMMON_SETTINGS>
</SMSQLCONFIG>