About this section This section describes how to use control-file based configuration to configure basic SnapManager settings. The following topics are covered in this section:
◆ “About control-file” on page 127
◆ “Importing and exporting configuration settings” on page 128
◆ “Sample XML schema for the control-file settings” on page 130
About control-file The control-file is an XML file that contains SnapManager configuration information. The configuration data is represented in XML format. It can be edited manually.
Note
To avoid syntax errors, use an XML editor to edit the control-file configuration.
You can access the control-file option from the SnapManager Configuration wizard. You can use the control-file as an alternative to the SnapManager configuration wizard to configure SnapManager. This is especially useful in the following scenarios:
◆ Multiple SQL Server database servers, databases, and LUNs
◆ Disaster recovery
◆ Mass deployment
The configuration settings contained in the control-file are grouped into the following sections:
◆ Storage layout
◆ Notification settings
◆ Verification settings
◆ Report directory setting
◆ Backup settings
◆ SnapMirror relationship settings
◆ Scheduled jobs
128 Understanding control-file based configuration
Importing and exporting configuration settings
The following tasks can be performed using the control-file:
◆ Export the current configuration details to a control-file.
◆ Export a specific section of current configuration to a control-file.
◆ Import configuration details from a control-file.
◆ Import a specific section of configuration information from a control-file.
To import or export configuration settings, complete the following steps:
Step Action
1 If you have not already done so, start SnapManager by accessing the Windows Start menu, and selecting Program Files > NetApp>
SnapManager for SQL Server.
Result: The SnapManager for SQL Server console appears.
2 In the Scope pane, double-click SnapManager for SQL Server.
Result: SnapManager displays the Status dashboard in the Result pane.
3 Click the SQL Server database server that you want to configure.
4 In the Actions pane, click Configuration Wizard.
Result: The Configuration Wizard launches and the Welcome win-dow appears.
5 Select the “Use control-file” check box.
6 Click Next.
Result: The Import or Export Selection window appears.
Chapter 7: Using the SnapManager Configuration Wizard 129
7 Select either the Import or the Export option.
Selecting the Import option will enable the Review current settings in the Configuration wizard check box. Select this check box to review imported settings in the configuration wizard.
If you have selected the Import option and unchecked the Review settings in the configuration wizard, SnapManager will proceed to the normal configuration wizards for you to confirm the imported configuration settings.
Selecting the Export option causes the Review current settings in the Configuration wizard check box to be grayed out.
If you selected the Export option, SnapManager exports the current configuration and settings to the control-file.
8 In the Use control-file check box, select the control-file path.
SnapManager uses the default path C:\Program Files\NetApp\SnapManager for SQL
Server\SMSQLConfig_mm_dd_yyyy_hh.mm.ss.xml.
9 Click Advanced.
10 In the Configuration Import/Export Advanced options window, specify the configuration settings that need to be imported or exported.
11 Click OK to confirm the configuration specification or Cancel to go back to the Import or Export Selection window.
If SnapManager detects that there is some missing data in any of the selected options, it prompts you if you still want to carry out with the configuration.
12 Click Next to proceed.
Result: The Verification Settings screen appears.
13 Select the verification server and the connection to be used. The connection can be Windows Authentication or SQL Server Authentication.
Step Action
130 Understanding control-file based configuration
Sample XML schema for the control-file settings
The SnapManager schema file is distributed with the installation package. The following configuration file depicts 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" ?>
14 If you selected SQL Server Authentication, enter the login name and password.
Result: SnapManager loads the control-file and validates the imported configuration and settings.
Step Action
Chapter 7: Using the SnapManager Configuration Wizard 131
132 Understanding control-file based configuration
Chapter 7: Using the SnapManager Configuration Wizard 133
134 Understanding control-file based configuration
Chapter 7: Using the SnapManager Configuration Wizard 135
136 Understanding control-file based configuration
Chapter 7: Using the SnapManager Configuration Wizard 137
Notification settings: The following schema depicts the notification settings section. You can edit the notification settings using an XML editor.
-<COMMON_SETTINGS>
<SUBJECT>SnapManager for SQL Server</SUBJECT>
<NOTIFY_AUTO>true</NOTIFY_AUTO>
<LONG_MSG>false</LONG_MSG>
<AS_ATTACHMENT>false</AS_ATTACHMENT>
138 Understanding control-file based configuration
Verification settings: The following schema depicts the verification settings section. You can edit the verification settings using an XML editor.
-<VERIFICATION>
<MP_DIR>C:\Program Files\NetApp\SnapManager for SQL Server\SnapMgrMountPoint</MP_DIR>
</VERIFICATION_SERVER_SETTING>
</VERIFICATION>
Report directory settings: The following schema depicts the report directory settings section. You can edit the report directory settings using an XML editor.
<REPORT_DRIECTORY>C:\Program Files\NetApp\SnapManager for SQL Server\Report</REPORT_DRIECTORY>
Backup settings: The following schema depicts the backup settings section.
You can edit the backup settings using an XML editor.
-<BACKUP>
Chapter 7: Using the SnapManager Configuration Wizard 139
SnapMirrored volumes settings: The following schema depicts the SnapMirror relationship settings section. You can edit the SnapMirror relationship settings using an XML editor.
-<VERIFICATION_ON_DESTINATION>
Schedule job settings: The following schema depicts the schedule job settings section. You can edit the schedule job settings using an XML editor.
-<VERIFICATION_ON_DESTINATION>
140 Understanding control-file based configuration
<JOB_NAME>bkup1</JOB_NAME>
<HOST_NAME>snapmgr-19</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>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>
<START_TIME>11/6/2007 1:32:00 PM</START_TIME>
Chapter 7: Using the SnapManager Configuration Wizard 141
<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 'SNAPMGR-19' -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>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 'SNAPMGR-19' -del -rtbkups 2 -lgbkafbk -noutm -uniq ñmgmt standard</COMMAND>
<START_TIME>11/11/2007 2:00:00 AM</START_TIME>
-<SQLAGENTSCHEDULES>
142 Understanding control-file based configuration
<START_DATE_TIME>11/5/2007 12:00:00 AM</START_DATE_TIME>
<START_TIME_OF_DAY>02:00:00</START_TIME_OF_DAY>
<END_DATE_TIME>12/31/9999 12:00:00 AM</END_DATE_TIME>
<END_TIME_OF_DAY>23:59:59</END_TIME_OF_DAY>
<FREQUENCY_TYPE>Weekly</FREQUENCY_TYPE>
<FREQUENCY_INTERVAL>1</FREQUENCY_INTERVAL>
<FREQUENCY_SUBDAY_TYPE>Once</FREQUENCY_SUBDAY_TYPE>
<FREQUENCY_SUBDAY_INTERVAL>0</FREQUENCY_SUBDAY_INTERVAL>
<FREQUENCY_RELATIVE_INTERVAL>First</FREQUENCY_RELATIVE_INTERVAL>
<FREQUENCY_RECURRENCE_FACTOR>1</FREQUENCY_RECURRENCE_FACTOR>
</SQLAGENTSCHEDULES>
</JOB>
</SCHEDULE_JOBS>
</COMMON_SETTINGS>
</SMSQLCONFIG>
Chapter 7: Using the SnapManager Configuration Wizard 143