Storing times in a varchar isn't is the best of ideas. SQL 2012 onwards has a time datatype, I would suggest making use of this (it'll save you hassle like...

You could try installing SSMS 2017, see if you experience a similar problem.

Hour and a half into our DR test, tape drive is yet to catalog. Good start to the day >_<. Going to be a looooong week.

I would guess that you you have a one to many relationship somewhere. Thus when doing your COUNT you are counting the same row twice.

Without seeing your data,...

Could you elaborate a bit more? Do you simply mean you wish to create a backup on a shared folder on the network? For example (without any WITH clauses):

Thanks guys for all the replies. I'm experimenting with the indexed computed column, as this is probably the most viable option for me. What I'm trying to overcome now is...

You can create a Connect item here: https://connect.microsoft.com/SQLServer/Feedback