Restore Data Using Wildcard Expressions

Table of Contents

Overview

Wildcard expressions can be used to restore file system data. This function provides the ability to restore files and/or folders/directories that have a common naming convention. For example, msde2.txt and msj4j.txt.

A combination of wildcards in a single expression (e.g., access?.h*) can also be used. If the expression is specified by itself, without a path (*.txt), the system searches for and returns all data within the backup set that satisfies the expression. By preceding the expression with a path, the scope of the restored data can be narrowed. For example, specifying sys:\data\*.txt, would restore only those files and directories within the sys:\data directory with extensions of .txt.

When restoring directories, if a wildcard pattern that matches the name of a directory was specified, the system restores the directory, but none of the directory's contents. For example, if the wildcard restore string is tem?, the system restores any and all data named with a four-character string starting with the letters t, e, and m. If a directory name satisfies the wild card condition (e.g., sys:\temp) then only the directory would be restored; however, none of the files or any subdirectories contained therein are restored.

Agents That Support Wildcard Expressions

See Restore/Recover/Retrieve Options - Support for a list of common restore/recover/retrieve options supported by agents. 

Find and Restore Data Using Wildcard Expressions

You can find files with specific names or name patterns. Wildcard expressions can be used to match specific file name patterns.