Significance of backup_set_id field in restorehistory table??

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 7,2000 » Backups » Significance of backup_set_id field in...

Significance of backup_set_id field in restorehistory table??

Rate Topic

Display Mode

Topic Options

Author

Message

dilip-196624

Posted Thursday, June 23, 2005 8:37 AM

Valued Member

Group: General Forum Members
Last Login: Friday, May 01, 2009 6:01 AM
Points: 74, Visits: 2

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

Post #193511

dilip-196624

Posted Thursday, June 23, 2005 11:15 PM

Valued Member

Group: General Forum Members
Last Login: Friday, May 01, 2009 6:01 AM
Points: 74, Visits: 2

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.

Post #193797

w2bsqldba

Posted Monday, February 13, 2012 1:41 PM

Forum Newbie

Group: General Forum Members
Last Login: Today @ 9:50 AM
Points: 5, Visits: 410

thanks

Post #1251496

« Prev Topic | Next Topic »

Permissions