12857: Acronis Backup Advanced: Large Size of Acronis Database on SQL Server

Symptoms

Sample scenario 1:

  • You use an existing SQL server for storing the databases used by Acronis Management Server (instead of SQL Express 2005 that comes with Acronis installation package);
  • In Acronis database on SQL Server, acronis_cms_cards_log.ldf grows to considerable size (100 GB or more)

Sample scenario 2:

  • You use an SQL Express 2005 that comes with Acronis installation package;
  • In Acronis database on SQL Server, acronis_cms_cards_.mdf database outgrows 4 GB;
  • In Windows event log you may see an error message similar to the following one:

    "CREATE DATABASE or ALTER DATABASE failed because the resulting cumulative database size would exceed your licensed limit of 4096 per Database"

Cause

Sample scenario 1:

Most probably, databases used for storing Acronis Management Server logs on the SQL server are set to Full Recovery model. Under Full Recovery model, transaction logs can grow and get rather large in size. 

SQL Express 2005 included in the installation package uses Simple Recovery model. Microsoft SQL Server 2008 uses Full Recovery model by default.

See MSDN Article: Recovery model overview.

Sample scenario 2:

Database acronis_cms_cards_.mdf contains synchronization information for the agents such as Backup policies, Tasks and other various information about Agent machines. In some cases, during an upgrade procedure there may not be enough space in the database to process the command.

Solution

Sample scenario 1:

Change Acronis databases to Simple Recovery model. See MSDN Article: How to: View or Change the Recovery Model of a Database.

Sample scenario 2:

  1. On the computer where Acronis Management Server and SQL Express 2005 are installed, click Start -> Run and type cmd;
  2. Click OK and execute the following command in command-line:

    osql -E -S .\ACRONIS -d acronis_cms_cards -Q "TRUNCATE TABLE IncomingCardsLog; TRUNCATE TABLE SyncWorkersResults; TRUNCATE TABLE SyncWorkersLog; DBCC SHRINKDATABASE(N'acronis_cms_cards')"

If you get errors concerning the size of acronis_cms_logs database or if database simply grows too large, run the following command to shrink it:

 osql -E -S .\ACRONIS -d acronis_cms_logs -Q "DBCC SHRINKDATABASE(N'acronis_cms_logs')"

You can also execute these commands in the SQL Server Management Studio:

  1. Start SQL Server Management Studio and connect to the instance used by Acronis Management Server.
  2. Under Databases select acronis_cms_cards.
  3. Select New Query.
  4. Execute:
    TRUNCATE TABLE IncomingCardsLog; TRUNCATE TABLE SyncWorkersResults; TRUNCATE TABLE SyncWorkersLog; DBCC SHRINKDATABASE(N'acronis_cms_cards')

More information

Contact Acronis Customer Central if you have any questions or need assistance.

Tags: