bak'
Far fewer fields of information are returned by this command because it gives only
general information as to the contents of a backup device (whether it??™s a file or a tape
device). For the most part, the information is straightforward, with a couple of exceptions.
Table 3-2 describes the most important of the fields returned.
Table 3-2. Information Returned by RESTORE FILELISTONLY
Field Label Information Returned
LogicalName The logical name of the backup file.
PhysicalName The physical location of the backup file, not the physical location of the database
file(s) being backed up.
Type This can be a data file (D), a log file (L), or a full-text catalog (F). I??™ll cover the
inclusion of full-text catalogs in backups in Chapter 4.
FileGroupName This is the SQL Server filegroup name that contains this file. A full-text catalog is
associated with a specific filegroup.
FileID This corresponds to the Position field shown by the RESTORE HEADERONLY
command.
Again, there are a number of other columns, but they??™re either used mostly internally
(more LSN information) or stored in other locations as well (such as SizeInBytes).
Pages:
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136