Guidelines for using the command-line utility

SmSqlBi enables you to enter SnapManager backup and verification commands individually or through automation scripts.

Location of the command-line utility

The SmSqlBi command-line utility is located in the SnapManager installation directory. The default installation directory for SnapManager 2.1 for Microsoft SQL Server is as follows:

C:\Program Files\NetAppSnapManager for SQL Server\

Summary of parameters

When you launch SmSqlBi, it displays a summary of parameters as shown below.

Usage: SmSqlBi -H <Sql Server host name> [-U <Login> -P <Password>]

-S <SQL Server Name> -C <Number of databases> <Database Name>..

-D <Number of backups to keep>

-R <Retain up-to-the-minute restore ability for older backups in 
other management groups>

-K <Number of SnapInfo Drive Snapshots to keep>

[-Q <Verification Server> [-I <verify Login> -W <verify Passwd>]]

[-mp[-mpdir mount_point_directory_path]]

-M <Number of backups to verify>

-A <Attach database after verification>

-RS <Run Command Server>

-RP <Run Command Path>

-RA <Run Command Arguments>

-X DBCC before backup

-Y DBCC after backup

-L Transaction log backup

-G Transaction log backup after full backup

-J Create Snapshot of SnapInfo Drive after backup

-O Remove inactive entries from transaction logs

-N No verification after backup

-Daily Daily management group

-Weekly Weekly management group

-Monthly Monthly management group

-All All management group

-UN Use "Time Stamp" naming convention

-UM Update SnapMirror after operation

Tips for using the command-line utility

Observe the following guidelines when using the SnapManager command-line feature:

All parameters and options are case-insensitive. For example, using the option -Daily will achieve the same results as using daily.
Some of the options must be invoked in a particular order. For best results, use the order given in the synopsis for all options.
When a parameter value string contains spaces, be sure to enclose it in double quotes. For example, use "First Backup Set" rather than First Backup Set.
When a parameter has a variable number of input values, it begins with a "count" value that you use to indicate how many values will be included in the parameter. If you specify a number different from the number of values included in the parameter, the command fails.
Note
When you use the SmsqlBi command-line utility with the switches -MPDIR[Mount Point Directory] and -MP, the corresponding values are set in the registry editor of the server. SnapManager for SQL uses the mount point directory that is specified to mount the Snapshot copy for verification. When you use the SmsqlBi command-line utility without the switches -MPDIR[Mount Point Directory] and -MP, the default settings are taken from the registry editor for verification.