HP 9000 rp5405 Servers - Manual (Page 388)

• To restore system databases (master, model, and msdb) together with a database that uses the
database mirroring function, disable the mirroring function for the database using it, restore the
system databases, and then restore the database that uses the mirroring function.
• In SQL Server 2005, the database configuration file of the resource database is stored in the same
location as the master database. Replication Manager does not quiesce the backup target or
display backup information because the resource database is a read-only database. But when a
replica of a system database is created or restored, a replica of the database configuration file
is created or restored along with the master database.
Unsupported functions
The following functions are not supported for SQL Server 2008:
• FILESTREAM data
• Capturing changed data
• Tracking of changes
• Compressing backup database and transaction log
• Compressing data
The following functions are not supported for SQL Server 2012:
• FILESTREAM data
• Capturing changed data
• Tracking of changes
• Compressing backup database and transaction log
• AlwaysOn failover cluster instance
• AlwaysOn usability group
• Server Core
Allocating files that comprise a database
Do not place database files to be backed up in the same volume as files that will not be backed up.
Allocating metafiles
A metafile is a file SQL Server outputs during backup processing. Metafiles store information about
database composition and are therefore used in restoration processing. For this reason, when backup
data is backed up to tape, the metafile must also be backed up to the tape.
If you have specified a VDI metafile storage directory, when backup data of the secondary volume
is backed up to tape, the metafile must also be backed up to the tape (this is not necessary if the
metafile is stored in the same directory as the database file).
When you back up to tape, use FTP or a similar method to transfer the metafile created in the metafile
storage directory in the database server to the backup server. Transfer the file in the directory using
the same name as in the metafile storage directory in the backup server and allocate the same drive
characters.
Metafile allocation on the database server and the backup server is shown in the following figure.
Managing application replicas 388