Acronis Backup for Windows Server Essentials - User Guide - Manual (Page 284)

284 Copyright © Acronis International GmbH, 2002-2014
11.1.1.4 SharePoint database files
SharePoint stores content, auxiliary SharePoint services' data and farm configuration in Microsoft
SQL Server databases.
To find database files in SharePoint 2010 or later
1. Open Central Administration site.
2. Select Upgrade and Migration > Review database status. You will see the SQL instance and
database name for all of the databases.
3. Use Microsoft SQL Server Management Studio to identify the files of the necessary database. For
detailed instructions, refer to "SQL Server database files" (p. 281).
To find the content database files in SharePoint 2007
1. Open Central Administration site.
2. Select Application Management > Content Databases.
3. Select a web application.
4. Selecta database. In the opened page you will see the database server and database name. Write
them down or copy to a text file.
5. Repeat step 4 for other databases of the web application.
6. Repeat steps 3-5 for other web applications.
7. Use Microsoft SQL Server Management Studio to identify the database files. For detailed
instructions, refer to "SQL Server database files" (p. 281).
To find the configuration or service database files in SharePoint 2007
1. Open Central Administration site.
2. Select Application Management > Create or configure this farm's shared services.
3. Right-click a shared services provider and select Edit properties. In the opened page you will see
the database server and database name. Write them down or copy to a text file.
4. Repeat step 3 for other shared services providers.
5. Use Microsoft SQL Server Management Studio to identify the database files. For detailed
instructions, refer to "SQL Server database files" (p. 281).
11.1.2 Truncating transaction logs
This section describes how to truncate transaction logs when protecting Microsoft Exchange and
Microsoft SQL servers by using disk backups.
The recommendations for SQL servers also apply to SQL servers included in a Microsoft SharePoint
farm. Active Directory databases normally use circular logging, so they do not need log truncation.
11.1.2.1 Transaction log truncation and log file shrinking for SQL Server
Acronis Backup does not truncate transaction logs after creating a disk backup. If you do not use the
native backup engine of Microsoft SQL Server or any other third-party backup solution that
automatically manages transaction logs, you can manage logs by using the following methods.

Transaction log truncation. Log truncation frees inactive virtual log files (that contain only
inactive log records) for reuse by new log records. Truncation may prevent a physical log file
from growing but does not reduce its size.
For more information about truncation refer to the following article:
http://technet.microsoft.com/en-us/library/ms189085(v=sql.105)