Which table in SQL shows items waiting for backup?

[James_Slack]

I have about 500k items waiting for backup after I thought I had got them all, so would like to see a list of what is outstanding.

We use the "ignorearchivetrigger.txt" method and it works fine for most stuff, just not these 500k odd items.

Any info would be great, but I know there is a table in SQL I can look at, just can't find it for looking.

Thanks

James

[James_Slack]

To clarify some things.

I am running EV10.

The Awaiting Backup I am talking about is seen on the web page "/enterprisevault/usage.asp"

Thanks

James

[AndrewB · Accepted solution]

have you had a look at the JournalArchive Table? i think the field is BackupComplete and the value will be either 0 or 1.

SELECT * FROM JournalArchive WHERE BackupComplete = '0'

[James_Slack]

I don't think that is what I am looking for.

We don't do journaling, only Mailbox archiving.

I am sure there is a table of outstanding items to be backed up. I have seen it before just don't know where.

Thanks

[AndrewB]

ignore the name :) this should get you what you're looking for

[James_Slack]

I found what I am looking for.

dbo.WatchFile.

That lists what I am looking for, I am pretty sure.

I will have a test with your suggstion and see if it shows what I am expecting and if so will mark as the answer.

Cheers - James

[James_Slack]

Yep, this is exactly what I was looking for, thanks.

Though I believe it is the same data as the watchfile... I may be wrong, but I think it is.

[AndrewB]

cheers

[James_Slack]

Actually, but of a problem making sense of this.

It gives a TransactionID and a SavesetID... but how do I know what files it actually is?

dbo.watchfile shows exactly the folder/files in question, so I know what needs backing up.

Any ideas?

[James_Slack]

Might have answered my own question... found the "IdPartition" entry... I can look that up to see which partition is having the issues.

Which table was that again?!

I'll start looking...

[James_Slack]

Found it - dbo.PartitionEntry obviously!

Thanks :)

[AndrewB]

perhaps you could do a JOIN by the ArchiveTransactionId to get the ItemName value from the WatchFile table?

[James_Slack]

Another question has now come from this, but i will start a new thread.