Thank you, I don't understand the logic there, but it appears to have fixed my "problem."

I would think that if I go back to where I bit the report...

Thanks Daniel! I will give this a go.

Edit: Worked like a charm! Thank you very much.

Thanks for the info so far. I will gather up what is requested and reply again soon. Thought I gave enough info/description. Still learning, appreciate the help!!

Nevermind, I apparently need to learn the difference between a table and a matrix! 🙂 I now have my total and think I can get the rest going. Sorry for...

Sean - I couldn't agree more...I am going to be working on that! I just started here 3 weeks ago and this is the second step of a cleanup process...

Here is a subset of the data showing the current problem. notice that 2a comes after 27n. there unfortunately is no pattern or set number of files that can or...

I just followed up that test with taking the TSQL from the differential step and doing the same thing to the file and name fields and it created a differential...

I just finished the manual backup. I copied the T-SQL out of the full backup step and just changed the name to be DBName_ManualTest.bak for the name and the file...

Well, I did change the path to seperate them for the noon run that should be happening soon. I am still expecting failure. Once that happens, I will try a...

I am still sitting here scratching my head on this one. Something that I don't think is the issue, I can store my Full backups and Differentials in the same...

I am seeing Transaction Log as the last one that ran, which technically would be correct. It ran at 9 am. I took out the distinct top 1 and in...

I used the restore verifyonly and got "The backup set on file 1 is valid."

So I think I have a complete, valid file as the logs would indicate. Next step?

I am moving a copy of the backup file to another server and am going to attempt a restore there to see if the file is good in that regard.

Just...

I just tried to run it manually, hadn't done that yet....and got the same error.

As far as I can tell, it is a complete good backup, according to the...

I just ran the query and on this particular server there are 3 Databases. Two of which are not even currently being used (they are older versions of the production...