Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Significance of backup_set_id field in restorehistory table?? Expand / Collapse
Author
Message
Posted Thursday, June 23, 2005 8:37 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 1, 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
Posted Thursday, June 23, 2005 11:15 PM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Friday, May 1, 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
Posted Monday, February 13, 2012 1:41 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Thursday, July 17, 2014 2:07 PM
Points: 5, Visits: 517
thanks

Post #1251496
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse