Post reply

Significance of backup_set_id field in restorehistory table??

  • June 23, 2005 at 8:37 am

    #167302

    Hi,

    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?

    Dilip

  • June 23, 2005 at 11:15 pm

    #568178

    Ok, 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.

  • February 13, 2012 at 1:41 pm

    #1446486

    thanks

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply