Export (0) Print
Expand All
Expand Minimize

restorefile

SQL Server 2000

The restorefile table 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.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft