Delen via


restorefile (Transact-SQL)

Contains one row for each restored file, including files restored indirectly by filegroup name. This table is stored in the msdb database.

Column name Data type Description

restore_history_id

int

Unique identification number that identifies the corresponding restore operation. References restorehistory(restore_history_id).

file_number

numeric(10,0)

File identification number of the restored file. This number must be unique within each database. Can be NULL.

When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.

destination_phys_drive

nvarchar(260)

Drive or partition to which the file was restored. Can be NULL.

When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.

destination_phys_name

nvarchar(260)

Name of the file, without the drive or partition information, where the file was restored. Can be NULL.

When a database is reverted to a database snapshot, this value is populated in the same way as for a full restore.

See Also

Reference

restorefilegroup (Transact-SQL)
restorehistory (Transact-SQL)
System Tables (Transact-SQL)

Help and Information

Getting SQL Server 2005 Assistance