restorefile (T-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 NOT NULL REFERENCES restorehistory(restore_history_id) Unique identification number identifying the corresponding restore operation.
file_number numeric(10,0) NULL File identification number of the restored file. This number must be unique within each database.
destination_phys_drive varchar(260) NULL Drive or partition to which the file was restored.
destination_phys_name varchar(260) NULL Name of the file, without the drive or partition information, where the file was restored.

  


(c) 1988-98 Microsoft Corporation. All Rights Reserved.