Question about backupset table

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2005 » Backups » Question about backupset table

Question about backupset table

Rate Topic

Display Mode

Topic Options

Author

Message

Abu Dina

Posted Wednesday, October 03, 2012 7:33 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 494, Visits: 2,155

Good afternoon,

This may sound like a daft question but the backupset table on one of my servers contains 6 different server names.

Can someone explain to me how this is possible? I expected to see just one unique name!

Thanks.

-----------------------------------
http://www.SQL4n00bs.com

Post #1367673

george sibbald

Posted Wednesday, October 03, 2012 8:05 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 5,270, Visits: 11,209

are you using log shipping?

---------------------------------------------------------------------

Post #1367698

Abu Dina

Posted Wednesday, October 03, 2012 8:10 AM

SSC-Addicted

Group: General Forum Members
Last Login: Today @ 6:53 AM
Points: 494, Visits: 2,155

No, no log shipping.

I've done a bit more checks and it appears to be very old data. In fact the entries relate to databases that no longer exist in master.dbo.sysdatabases

I'm going to remove these entries as there is no need for them to be there!

Just intrigued how these ended up where they are. Very strange.

Thanks.

-----------------------------------
http://www.SQL4n00bs.com

Post #1367703

george sibbald

Posted Wednesday, October 03, 2012 8:19 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 6:09 AM
Points: 5,270, Visits: 11,209

Any database restore from another server across the network will result in an entry in the backupset table.

check msdb..restorehistory as well

---------------------------------------------------------------------

Post #1367715

« Prev Topic | Next Topic »

Permissions