Running Operations Using CvSQLBackupUtility Tool

You can run the following operations using the CvSQLBackupUtility tool:

Connecting to a specific instance

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation Connect /instance instance_name

For example:

CvSQLBackupUtility.exe /operation Connect /instance Server1\Instance1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Discovering instances

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation DiscoverInstances

For example:

CvSQLBackupUtility.exe /operation DiscoverInstances /quiet /logfile “mylog.txt”

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Discovering databases

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation DiscoverDatabases /instance instance_name

For example:

CvSQLBackupUtility.exe /operation DiscoverDatabases /instance Server1\Instance1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting backup information for a specific backupset

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetBackupInfo /backupsetid backupsetID_name

For example:

CvSQLBackupUtility.exe /operation GetBackupInfo /backupsetid 1234

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting backup information for a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetDatabaseBackupInfo /instance instance_name /database database_name

For example:

CvSQLBackupUtility.exe /operation GetDatabaseBackupInfo /instance Server1\Instance1 /database DB1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting raw files for a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetNewFiles /instance instance_name /database database_name /backupsetid backupsetID_name

For example:

CvSQLBackupUtility.exe /operation GetNewFiles /instance Server1\Instance1 /database DB1 /backupsetid 1234 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting full-text catalogs for a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetNewFullTextCatalogs /instance instance_name /database database_name /backupsetid backupsetID_name

For example:

CvSQLBackupUtility.exe /operation GetNewFullTextCatalogs /instance Server1\Instance1 /database DB1 /backupsetid 1234 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting recovery model for a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetRecoveryModel /instance instance_name /database database_name

For example:

CvSQLBackupUtility.exe /operation GetRecoveryModel /instance Server1\Instance1 /database DB1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting restore information for a specific backupset

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetRestoreInfo /backupsetid backupsetID_name

For example:

CvSQLBackupUtility.exe /operation GetRestoreInfo /backupsetid 1234

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting restore information for a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetDatabaseRestoreInfo /instance instance_name /database database_name

For example:

CvSQLBackupUtility.exe /operation GetDatabaseRestoreInfo /instance Server1\Instance1 /database DB1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting the server version for a specific instance

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetServerVersion /instance instance_name

For example:

CvSQLBackupUtility.exe /operation GetServerVersion /instance Server1\Instance1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Getting status of a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation GetStatus /instance instance_name /database database_name

For example:

CvSQLBackupUtility.exe /operation GetStatus /instance Server1\Instance1 /database DB1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Truncate logs of a specific database

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation TruncateLog /instance instance_name /database database_name

For example:

CvSQLBackupUtility.exe /operation TruncateLog /instance Server1\Instance1 /database DB1 /user User1 /password Password1

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Running a backup operation

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation Backup /instance instance_name /database database_name /backupfile backupfile_name

For example:

CvSQLBackupUtility.exe /operation Backup /instance Server1\Instance1 /database DB1 /user User1 /password Password1 /backupfile “C:\MyBackups\MyDB.bkp” /devicecount 2 /blocksize 8192 /buffercount 4 /maxtransfersize 131072 /vditimeout 420

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Running a restore operation

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation Restore /instance instance_name /database database_name /backupfile backupfile_name

For example:

CvSQLBackupUtility.exe /operation Restore /instance Server1\Instance1 /database DB1 /user User1 /password Password1 /backupfile “C:\MyBackups\MyDB.bkp” /devicecount 1 /blocksize 8192 /buffercount 4 /maxtransfersize 131072 /vditimeout 420

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Restoring database to a different location

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation Restore /instance instance_name /database database_name /backupfile backupfile_name /renameparams “MOVE File1 TO Location1, MOVE File2 TO Location2”

For example:

CvSQLBackupUtility.exe /operation Restore /instance Server1\Instance1 /database DB1 /user User1 /password Password1 /backupfile “C:\MyBackups\MyDB.bkp” /renameparams “MOVE ‘MyDB’ TO ‘C:\ExistingDir\MyDB.mdf’, MOVE ‘MyDB_Log’ TO ‘C:\ExistingDir\MyDB.ldf’”

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Running a query operation

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /operation PerformQuery /instance instance_name /database database_name /query T-SQL_command

For example:

CvSQLBackupUtility.exe /operation Backup /instance Server1\Instance1 /database DB1 /query “CREATE TABLE NewTable (Field1 varchar(256), Field2 int)”

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.

Displaying help for CvSQLBackupUtility

On the command line, run the following operation after substituting the parameter values:

CvSQLBackupUtility.exe /help

For detailed information about parameters, see Available Parameters for CvSQLBackupUtility Tool.