User guide

129 Copyright © Acronis International GmbH, 2002-2013
 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 (p. 37)
 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 (p. 19) command. See the examples in the
"Disks and volumes" (p. 121) section under "Single-pass disk and application backup".
Recovering Microsoft SQL databases (p. 38)
 Recovering a database from the latest backup of an archive. Since the --target (p. 80)
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