Knowledge base 148: Backing up IA Main SQL Database via a command prompt

The following can be used from CMD to backup a name database on the identity access SQL instance.

Run a Windows command prompt and use the commands below:

WIndows Authentication : 

sqlcmd -E -S .\identityaccess -Q "BACKUP DATABASE IAMAIN TO DISK='c:\temp\IAMainBackup.bak'"

SQL Server Authentication : 

SQLCMD -S .\IDENTITYACCESS -U sa -P (Insert_SA_PasswordHere) -Q "BACKUP DATABASE IAMAIN TO DISK='c:\temp\IAMainBackup.bak'"

Change the SQL instance, location, Password (if using SQL Login)  and backup name if required - location must be in ' ' single quotes.

Once the backup completes successfully you will see the name of the files used in the database and a success or failed message.

Processed 4616 pages for database 'IAMAIN', file 'IADataFile' on file 1.

Processed 2 pages for database 'IAMAIN', file 'IADataFile_log' on file 1.

BACKUP DATABASE successfully processed4618 pages in 5.096 seconds (7.079 MB/sec).

​

• Related Articles

• Knowledge base 107: Using SQL Backup Master to backup and restore SQL Databases.

  The following Bulletin explains how to install and configure SQL Backup Master to backup and restore SQL databases. Installing SQL Backup Master & Creating a Backup 1. Download SQL Backup Master from the following link – ...

• Knowledge base 116: SQL Error when running IA Database Wizard.

  Occasionally when installing Identity Access the error (shown below) is displayed while creating the databases using the Database Wizard. The following checks and steps can be taken to resolve this error - 1.     Ensure the Server Name in the ...

• Knowledge base 118: MA Sigma Stand alone USB Backup & Restore

  It is possible to backup and restore the Users stored in the MA Sigma via the touchscreen display. This is only required when the device is in a stand-alone scenario e.g. Not connected to Identity Access or MorphoManager where you have the ability to ...

• Knowledge base 113 : Update Existing IA system for a new SQL login.

  The following bulletin explains how to change the settings of an existing installation of Identity Access (IA) to allow for new SQL login details. This is based on using IA version 2017.1, if you are not using this version please upgrade by either ...

• Knowledge base 201: Moving Identity Access server to another machine

  Checking your Identity Access License When moving Identity Access from one machine to another it is important to check if the current Identity Access server has a Professional or Enterprise license and what version the software is currently running. ...