Skip to main content
  • Place orders quickly and easily
  • View orders and track your shipping status
  • Enjoy members-only rewards and discounts
  • Create and access a list of your products

PowerProtect Data Manager 19.9 Microsoft Application Agent SQL Server User Guide

PDF

Naming conventions for backups with VM Direct

When naming 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 SQL stand-alone, cluster, and Always On availability group configurations with VM Direct.

Table 1. 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 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.

  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please provide ratings (1-5 stars).
  Please select whether the article was helpful or not.
  Comments cannot contain these special characters: <>()\