PowerProtect Data Manager 19.15 Microsoft SQL Server User Guide

PDF

Naming conventions for backups with VM Direct

When naming Microsoft SQL Server instance, 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.

Therefore, if there are two or more databases with the same name but with different capitalization, such as DB1 and db1, the Microsoft application agent views these databases as the same and by default backs up only one of the databases.

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

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

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 will fail.