PowerProtect Data Manager 19.17 Microsoft SQL Server User Guide

PDF

Naming conventions for backups with VM Direct

When naming Microsoft SQL Server instances, database, and filegroups, consider that the Microsoft application agent does not distinguish the difference between upper and lowercase letters. The names are not case-sensitive.

The Microsoft application agent considers two or more databases with the same name but different capitalization, such as DB1 and db1, to be the same database. By default, the Microsoft application agent backs up only one of the databases.

NOTE:

While Microsoft SQL Server supports naming instances with the hash symbol (#), the Microsoft application agent does not. If an instance includes a hash symbol, backups of that instance fail.

Asset discovery fails when the Microsoft SQL Server asset names include Chinese characters from the following asset names:

The following table describes the special characters that are supported with VM Direct. These characters are supported for naming database backups in Microsoft SQL Server standalone, cluster, and Always On availability group configurations.

Table 1. Special characters supported with VM DirectTable of special characters supported with VM Direct
Special character	Name
~	Tilde
`	Accent grave
!	Exclamation mark
@	At the rate
%	Percentage
^	Caret
&	Ampersand
(	Open parenthesis
)	Close parenthesis
-	Hyphen
_	Underscore
{	Open curly bracket
}	Close curly bracket.
\	Backslash
.	Period