Loading...

Available Operations for CvSQLBackupUtility Tool

Parameters

Description of Parameter Values

Connect

Use this operation to connect to a specific instance.

You can use the following parameters with this operation:

/instance <instance>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

DiscoverInstances

Use this operation to discover instances in the local SQL server only.

You can use the following parameters with this operation:

[/logfile <logfilename>]

[/quiet]

[/verbose]

DiscoverDatabases

Use this operation to discover databases in the SQL server.

You can use the following parameters with this operation:

/instance <instance>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetBackupInfo

Use this operation to get back up information for a specific backupset.

You can use the following parameters with this operation:

/instance <instance>

/backupsetid <backupsetid>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetDatabaseBackupInfo

Use this operation to get back up information for a specific database.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetNewFiles

Use this operation to get a list of the raw (underlying file-system) files for a database that were created after the specified backup set was created.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/backupsetid <backupsetid>]

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetNewFullTextCatalogs

Use this operation to get a list of the full-text catalog directories for a database that were created after the specified backup set was created.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/backupsetid <backupsetid>]

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetRecoveryModel

Use this operation to get recovery model for a specific database.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetRestoreInfo

Use this operation to get restore information for a specific backup set.

You can use the following parameters with this operation:

/instance <instance>

/backupsetid <backupsetid>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetDatabaseRestoreInfo

Use this operation to get restore information for a specific database.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetServerVersion

Use this operation to get server version for a specific instance.

You can use the following parameters with this operation:

/instance <instance>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

GetStatus

Use this operation to get status of a specific database.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

TruncateLog

Use this operation to truncate logs of a specific database.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

Backup

Use this operation to run a backup operation.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

/backupfile <bkpfilename>

[/blocksize <blocksize>]

[/buffercount <bufcount>]

[/compression]

[/devicecount <devcount>]

[/maxtransfersize <transfersize>]

[/nocopyonly]

[/nofileio]

[/novdi]

[/vditimeout <vditimeout>]

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

Restore

Use this operation to run a restore operation.

You can use the following parameters with this operation:

/instance <instance>

/database <database>

/backupfile <bkpfilename>

[/blocksize <blocksize>]

[/buffercount <bufcount>]

[/devicecount <devcount>]

[/maxtransfersize <transfersize>]

[/novdi]

[/renameparams <movecommands>]

[/vditimeout <vditimeout>]

[/verifyonly]

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

PerformQuery

Use this operation to perform any T-SQL command. This command can modify the properties of a database or the entire SQL server.

Caution: If the command is a query that is to return results, these results are not displayed.

You can use the following parameters with this operation:

/instance <instance>

/query <query>

[/user <username>]

[/password <password>]

[/logfile <logfilename>]

[/quiet]

[/verbose]

Help

Use this operation to display all the operations and parameters that you can use while executing CvSQLBackupUtility.exe tool.

Note: Optional parameters are enclosed within the square brackets [..], and mandatory parameters are without the square brackets.

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