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.