Microsoft SQL

Listing Microsoft SQL Server instances

• Listing Microsoft SQL Server instances on the local machine.

  acrocmd list mssql_instances

• Listing instances of Microsoft SQL Server 2005 that are located on a remote machine and whose names contain the fragment "WEB".

  acrocmd list mssql_instances --host=192.168.1.2 --credentials=user1,pass1 --filter_edition=2005 --filter_name=WEB

Listing Microsoft SQL databases

• Listing databases of a Microsoft SQL Server instance located on a remote machine. Since the --credentials parameter is not specified after the --instance parameter, the software will use Windows Authentication (the credentials specified after the --host parameter) to connect to the specified instance.

  acrocmd list mssql_databases --host=192.168.1.2 --credentials=user1,pass1 --instance=WEBSERVER

• Listing only those databases of the "NEWSERVER" instance whose names contain the fragment "account". Since the --credentials parameter is specified after the --instance parameter, the software will use SQL Server Authentication to connect to the instance.

  acrocmd list mssql_databases --instance=NEWSERVER --credentials="SQL user",pass --filter_name=account

Backing up Microsoft SQL servers

This operation is performed by using the backup disk command. See the examples in the "Disks and volumes" section under "Single-pass disk and application backup".

Recovering Microsoft SQL databases

• Recovering a database from the latest backup of an archive. Since the --target parameter is not specified, the database will be recovered to the original instance. The user who runs the command must be a member of the sysadmin role on this instance. If a database with the same name exists in this instance, it will be overwritten. The database will be recovered in the norecovery state so that you can recover additional transaction logs from the native Microsoft SQL backups.

  acrocmd recover mssql_database --loc=\\srv1\backups --credentials=netuser1,pass1 --arc=machine1_app --items=WEBSERVER/Accountants --overwrite --database_state=norecovery

• Extracting all databases of an instance from the specified backup. The database files along with the transaction log files will be saved to a network share.

  acrocmd recover mssql_database --loc=\\srv1\backups --credentials=netuser1,pass1 --arc=machine1_app --backup=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX --items=NEWSERVER --target=disk --disk_location=\\host\share --credentials=netuser,pass

• Recovering two databases from the specified backup. The databases will be recovered to another instance. If a database with the same name exists in the that instance, the recovered database will be renamed. Since the --database_state parameter is not specified, the databases will be recovered in the recovery state and will be ready for use.

  acrocmd recover mssql_database --loc=bsp://storage_node1/my_vault --arc=my_archive_app --backup=XXXXXXXX-XXXX-XXXX-XXXX-XXXXXXXXXXXX --items=WEBSERVER/Accountants,NEWSERVER/Anna --target=another_instance --destination_instance=SUPERVISION --credentials="SQL user",pass2 --database_location=D:\databases --autorename

  If the user who runs the command is a member of the sysadmin role on the destination instance, the --credentials parameter is not needed after the --destination_instance parameter. Otherwise, you need to specify the sysadmin credentials.