TFS backupsets.xml shows all backup sets including the deleted.

Monday, July 30, 2012 5:46 PM

0

Hello,

I'm using TFS power tools backup/restore wizard and when I select "list backups" it shows all backup sets from my very first backup (I've been running it for at least 4 months). My retention is set for 15 days. Old backups deleted as they should but the backupsets.XML file doesn't get updated. I can probably go and delete old references manually but thought the scheduled task should do it automatically.

Please Advise,

Thanks

All Replies

Tuesday, July 31, 2012 6:57 AM

Moderator

0

Hi D777,

Thanks for your post.

What’s the version of your TFS Power Tools?

According the description, the BackupSets.xml file not be updated, the should deleted backup database names still displayed in the BackupSets.xml file.

So, what about the backup database files(bak and trn)? The backup database files(which created time older than 15 days) still existed in your backup folder?

I created a new backup plan and set retention days to 15, then check if I can reproduce this scenario.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
Tuesday, July 31, 2012 11:32 PM

0

Hi John,

Thanks for your reply. Bak and trn files are getting deleted as they should. It's just backupsets.xml doesn't get updated. When I list backup sets under Restore wizard it shows old databases with the size 00.

When I look at the installer for the power tools it shows Content created : 12/7/2011 So I assume it's a latest one.

Thanks,
Wednesday, August 01, 2012 3:01 AM

Moderator

0
Hi D777,

Thanks for your reply.

I will tracking this issue in my BackupSets.xml file, check if I can reproduce this issue.

Currently, you can try to recreate your backup plan, then check the BackupSets.xml file will be updated or not.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
- Marked As Answer by John QiaoMicrosoft Contingent Staff, Moderator Tuesday, August 21, 2012 3:29 AM
Friday, August 03, 2012 9:47 AM

Moderator

0
Hi D777,

After recreated the new backup plan, the BackupSets.xml file be updated correctly?

John Qiao [MSFT]
MSDN Community Support | Feedback to us
- Edited by John QiaoMicrosoft Contingent Staff, Moderator Friday, August 03, 2012 9:47 AM
Friday, August 03, 2012 3:55 PM

0

Hi John,

It's a production server and I'm trying not to do anything at least while we're in the middle of the development. Does your XML file get updated (do old entries get removed?)

Thanks,

D
Monday, August 06, 2012 2:46 AM

Moderator

0

Hi D,

Thanks for your reply.

Yes, my BackupSets.xml file updated fine. But I also set the Retention Days to 15, after the backup files older than 15 days, I will check the BackupSets.xml file again(about at 8/15/2012).
John Qiao [MSFT]
MSDN Community Support | Feedback to us
Monday, August 06, 2012 6:51 PM

0

Thanks John.
Monday, August 20, 2012 7:32 AM

Moderator

0

Hi D,

Thanks for your reply.

I have checked my BackupSets.xml file, it be updated fine, the all the backup files which older than 15 days be removed from the list in BackupSets.xml file.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
Monday, August 20, 2012 4:17 PM

0

Thanks John.
Tuesday, August 28, 2012 7:28 PM

0

John,

I just checked the XML file and looks like the only old entries that are there that belong to WSS backup. Since TFS is not doing transactional backup of WSS the show up empty and when the scheduler runs cleanup job it removes actual backup files and its reference in XML file. Since there are no WSS trans backup files present it would leave the reference in XML. Bellow is example
<TfsBackupSet Id="20120828121504" Time="2012/08/28 12:15:04">
      <Databases>
<BackupSetDatabase Name="Tfs_Configuration" File="Tfs_Configuration_20120828121504L.trn" Parent="Tfs_Configuration_20120828114508L.trn" />
        <BackupSetDatabase Name="Tfs_DefaultCollection" File="Tfs_DefaultCollection_20120828121504L.trn" Parent="Tfs_DefaultCollection_20120828114508L.trn" />
        <BackupSetDatabase Name="Tfs_Warehouse" File="Tfs_Warehouse_20120828121504L.trn" Parent="Tfs_Warehouse_20120828114508L.trn" />
        <BackupSetDatabase Name="ReportServer" File="ReportServer_20120828121504L.trn" Parent="ReportServer_20120828114508L.trn" />
        <BackupSetDatabase Name="ReportServerTempDb" File="ReportServerTempDb_20120828121504L.trn" Parent="ReportServerTempDb_20120828114508L.trn" />
        <BackupSetDatabase Name="WSS_Config" File="" Parent="" />
        <BackupSetDatabase Name="WSS_AdminContent" File="" Parent="" />
        <BackupSetDatabase Name="WSS_Content" File="" Parent="" />
      </Databases>
    </TfsBackupSet>

End the entries that would still be there after clean up job ran are

<TfsBackupSet Id="20120828121504" Time="2012/08/28 12:15:04">
      <Databases>
         <BackupSetDatabase Name="WSS_Config" File="" Parent="" />
        <BackupSetDatabase Name="WSS_AdminContent" File="" Parent="" />
        <BackupSetDatabase Name="WSS_Content" File="" Parent="" />
      </Databases>
    </TfsBackupSet>
Wednesday, August 29, 2012 3:20 AM

Moderator

0

Hi D,

Thanks for your reply.

It seems that you didn’t create the backup file(.bak) for your TFS Server, and the WSS backup .bak files lost the parent. I think you only selected to create the transactional(.trn) files in Backup Plan. To backup TFS using TFS Power Tools, I suggest you both select the bak and trn files in Backup Plan Wizard to create the backup files.

After created backup files using TFS Power Tools, the TFS BackupSet file should like the below:

<?xml version="1.0"?>

<BackupSets xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance">

<BackupSets>

    <TfsBackupSet Id="20120820152439" Time="2012/08/20 15:24:39">

      <Databases>

        <BackupSetDatabase Name="Tfs_Configuration" File="Tfs_Configuration_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="Tfs_DefaultCollection" File="Tfs_DefaultCollection_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="Tfs_Warehouse" File="Tfs_Warehouse_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="ReportServer" File="ReportServer_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="ReportServerTempDb" File="ReportServerTempDb_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="WSS_Config" File="WSS_Config_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="WSS_AdminContent" File="WSS_AdminContent_20120820152439F.bak" Parent="" />

        <BackupSetDatabase Name="WSS_Content" File="WSS_Content_20120820152439F.bak" Parent="" />

      </Databases>

    </TfsBackupSet>

    <TfsBackupSet Id="20120820152520" Time="2012/08/20 15:25:20">

      <Databases>

        <BackupSetDatabase Name="Tfs_Configuration" File="Tfs_Configuration_20120820152520L.trn" Parent="Tfs_Configuration_20120820152439F.bak" />

        <BackupSetDatabase Name="Tfs_DefaultCollection" File="Tfs_DefaultCollection_20120820152520L.trn" Parent="Tfs_DefaultCollection_20120820152439F.bak" />

        <BackupSetDatabase Name="Tfs_Warehouse" File="Tfs_Warehouse_20120820152520L.trn" Parent="Tfs_Warehouse_20120820152439F.bak" />

        <BackupSetDatabase Name="ReportServer" File="ReportServer_20120820152520L.trn" Parent="ReportServer_20120820152439F.bak" />

        <BackupSetDatabase Name="ReportServerTempDb" File="ReportServerTempDb_20120820152520L.trn" Parent="ReportServerTempDb_20120820152439F.bak" />

        <BackupSetDatabase Name="WSS_Config" File="" Parent="WSS_Config_20120820152439F.bak" />

        <BackupSetDatabase Name="WSS_AdminContent" File="" Parent="WSS_AdminContent_20120820152439F.bak" />

        <BackupSetDatabase Name="WSS_Content" File="" Parent="WSS_Content_20120820152439F.bak" />

      </Databases>

    </TfsBackupSet>

</BackupSets>

</BackupSets>
John Qiao [MSFT]
MSDN Community Support | Feedback to us
Wednesday, August 29, 2012 5:05 PM

0

Thanks John for the reply,

I do have WSS_Config, WSS_AdminContent and WSS_Content that show up in XML with the file name but only once a day. Basically if I start backup at 2:00AM it would show all databases backed up but then every 15min transactional backup would show WSS_Config, WSS_AdminContent and WSS_Content empty just like I referenced above until the next morning 2:00AM backup.

Thanks,
Thursday, August 30, 2012 6:36 AM

Moderator

0

Hi D,

Thanks for your reply.

Can you share the detailed settings for your Backup Plan? I need to reproduce that.
John Qiao [MSFT]
MSDN Community Support | Feedback to us
Thursday, August 30, 2012 3:54 PM

0

Hi John,

See bellow

Backups Retention Days: 30

Include reportin databases in the backup plan: checked

Include SharePoint databases in the backup plan : checked

DB Name: WSS_Config

Schedule: Full Backup Schedule: Sun at 02:00AM,

Differential Backup Schedule: Mon,Tue,Wed,Thu,Fri,Sat at 2:00AM

Transactional Backup Interval: 15min

Thanks,

D
Monday, September 03, 2012 11:10 AM

Moderator

0

Hi D,

Thanks for your reply.

I reproduced this scenario and received same result, the following entries still in BackupSets.xml file after clean up job.

  <TfsBackupSet Id="20120830110100" Time="2012/08/30 11:01:00">

      <Databases>

        <BackupSetDatabase Name="WSS_Config" File="" Parent="" />

        <BackupSetDatabase Name="WSS_AdminContent" File="" Parent="" />

        <BackupSetDatabase Name="WSS_Content" File="" Parent="" />

      </Databases>

    </TfsBackupSet>

For this scenario, I suggest you submit it to Microsoft Connect Feedback portal at: https://connect.microsoft.com/VisualStudio. Microsoft engineers will evaluate them seriously.
John Qiao [MSFT]
MSDN Community Support | Feedback to us