SQL doesn't by default have an "order" to return your result set by.  So when you issue a command like "SELECT Transaction_Date FROM Employee_Change", depending on various factors, you could...

You are missing some data there... or I misunderstand the request.
is the attached table the expected output, the sample input or something else?  If it is the sample input,...

We actually have a similar setup where I work and it was a lot of trial and error to get thigns to work optimally.
Even after we thought we had...

I've been trying to reply to this thread all day.

I apologize for the misinformation.  I did more snooping and I am definitely incorrect in what I had posted....

Possibly?  I personally have not experienced that specific issue.

Are you using BIDS 2008 (inside Visual Studio 2008) to create the report?  I've seen other SQL things have issues...

using "copy_only" makes a backup of the tlog but it does not do a truncate of the log when it completes.  According to Microsoft:
opy-only log backups (full recovery model...

It will not break the log chain (which I think is your goal), but it won't affect shrinking the log file.  In order to shrink the log file (not recommended)...

Are you viewing the reports in IE or some other browser?  I find that in SSRS prior to 2016, it is best viewed in IE.  In 2016 they made improvemnets,...

The Full backup would mark a checkpoint which is the start of the backup.  Any data that exists prior to that checkpoint would be in the full backup.  Any data...

That sounds like a short window for the upgrade.
What I would do is build an upgrade plan and rollback plan on paper first and then run through that on...

How'd the install go?  Are you happily running SQL 2008 R2 and 2016 on the same machine?

I've not seen that before without any errors in the logs.  When you look at the SQL Setup log, does it give any indication of what was updated?  And using...

Right... forgot about some of those things.  SQL Server Browser service would be one of the things upgraded but won't harm anything with that being upgraded.
As long as you...

Yep.  I'd do a full backup and since it is a VM, I'd do a snapshot as well.  It is a lot faster to restore from a snapshot than a...

I would install things into separate folders.  We generally install the shared stuff into the default folder (which is then separated by version) and the database files onto separate physical...