User manual

198 Copyright © Acronis International GmbH, 2002-2016
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. 195).
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. 195).
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. 195).
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 for SQL Server
Acronis Backup does not truncate transaction logs after creating a disk-level backup.
If you want to truncate transaction logs, there are two options:
 Switch the databases to the Simple Recovery Model. When using Simple Recovery, you cannot
back up the transaction log. Therefore, a database can be recovered only to a point in time of a
backup created by Acronis Backup (to be exact, to the moment of taking a snapshot). The backup
interval should be short enough to prevent the loss of significant amounts of data.