InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comMon, 20 May 2013 10:22:39 GMT20http://www.sqlservercentral.com/Forums/Topic193511-24-1.aspxthanksMon, 13 Feb 2012 13:41:05 GMTw2bsqldbahttp://www.sqlservercentral.com/Forums/Topic193511-24-1.aspxOk, I found it. Actually on the server where the database is being restored, theres a backupset table which is a replica of the backupset table of the originating server and the restorehistory table references this backupset id.Thu, 23 Jun 2005 23:15:00 GMTdilip-196624http://www.sqlservercentral.com/Forums/Topic193511-24-1.aspxHi,In SQL BOL, it states that the below description for backup_set_id in restorehistorytable************************************************************backup_set_id int NOT NULL REFERENCES backupset(backup_set_id) ************************************************************But I dont think whether it actually references or not, becoz i did a backup and restore(on network server) chekced the backup_set_id in both tables i.e. backupset as well as restorehistory tables, But both are having different ids? So i think it wont be any useful if we want to relate both the tables. Any thoughts?DilipThu, 23 Jun 2005 08:37:00 GMTdilip-196624