HP Serveur lame HP ProLiant BL465c Gen8 - Manual (Page 54)

database is backed up and restored along with the database configuration file of the master
database when the system database is backed up and restored.
• For SQL Server 2008, the data compression function is not supported.
• The following features of SQL Server 2008 and SQL Server 2012 are not supported:
• FILESTREAM Data
• Change Data Capture
• Change Tracking
• Backup Compression (Database and Transaction Log)
• SQL Server 2012 supports the following types of data compression:
• Row compression
• Page compression
• Columnstore indexes
• When SQL Server 2012 uses an AlwaysOn availability group configuration, operations for
backing up and restoring user databases on the active node are supported. The following operations
are not supported when using an AlwaysOn availability group configuration:
• An operation for backing up and restoring system databases
• An operation for backing up and restoring user databases on the passive node
• For SQL Server 2012, Server Core is not supported. Also, AlwaysOn failover cluster instance
operations using one of the following configurations are not supported:
• A database is stored in the shared folder for the network
•
tempdb is stored on a local disk
• A cluster is configured across multiple subnets
Allocating files that comprise a database
Allocate the database file backed up by Application Agent to a volume separate from files not to be
backed up.
Application Agent can back up only the database configuration files (the *.mdf and *.ndf data
files and the *.ldf transaction log file) and metafiles. Metafiles are generated when the backup
command is executed.
For database configuration files that are not subject to backup and for general files, no freezing
processing is executed. Therefore, if the primary volume contains a file that is not subject to the freezing
processing, pair partitions will be duplicated during file writing, resulting in loss of database integrity.
Allocate only the database configuration files subject to the freezing processing in the primary volume.
Allocation of database configuration files is shown in the figure below.
Application Agent system configurations 54