Available Parameters for CvSQLBackupUtility Tool


Description of Parameter Values


Use this parameter to run an operation. For more information, see Available Operations for CvSQLBackupUtility Tool.


This parameter specifies the name of the File System file.


The ID number of a backup or restore backupset. This parameter can be queried with the GetBackupInfo operation and GetRestoreInfo operation.


Size of the data blocks.

Default value is 65536.


Number of data blocks to use during backup or restore to improve performance.

Default value is one.


Use this parameter to compress the contents of the backup file.


Name of the database.


Use this parameter to control the number of backup files that are created for backup operation or read for restore operation.

Number of backup files created will be equal to the value of this parameter.


The name of the SQL instance. Use sqlservername for the default instance of a SQL Server. Use sqlservername\instancename for a non-default instance. sqlservername might be a short or a fully-qualified DNS name of a SQL Server. Some examples are MySQLServer, MySQLServer.MyDomain.com\Instance1


Fully qualified path or file name for a log file. CvSQLBackupUtility tool does not maintain a log file unless log file name is specified.


Maximum number of bytes to transfer at a time to tune performance.

Default value is 65536.


Use this parameter to perform a non-COPY_ONLY backup operation. By default, a COPY_ONLY backup operation is performed.

Caution: It might affect the normal production backup cycle.


Use this parameter to discard backup data and not write it to the backup file. You can use this parameter to test backups of large databases.

Caution: Do not use /nofileio and /nocopyonly parameters together as this might lead to data loss for the production backup cycle.


Use this parameter if the SQL server of the instance is not in the same computer from where the CvSQLBackupUtility.exe command is run. Using this parameter will cause all the files to be local to the SQL server of the instance.


Password of the login ID used to connect to the SQL server.


Use this parameter to suppress the display of output information. All output information will be written to the log file if "/logfile" parameter is specified. This parameter is useful when executing CvSQLBackupUtility.exe tool via a CMD script.


Use this parameter during a restore operation to restore the raw files of a database to a different location than where they were located when the database was backed up.


Login ID specified in the SQL server.

If not specified, the Windows credentials of the Windows user account executing the command are considered.


The time the system must wait for the SQL Server to become ready. Time value is in seconds.

Default value is 300.


Use this parameter to display and write all output information to the log file that would normally be hidden. An example of this hidden information is the connection attempt for all operations other than Connect.


Use this parameter during a restore operation to open and verify the backup file but the data is not restored to the database. You can use this parameter to verify if the previous backup was successful or not.

Last modified: 12/4/2018 5:25:38 AM