Viewing 15 posts - 2,251 through 2,265 (of 2,899 total)
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....
November 7, 2017 at 3:26 pm
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...
November 7, 2017 at 7:23 am
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...
November 7, 2017 at 7:13 am
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)...
November 6, 2017 at 2:45 pm
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,...
November 6, 2017 at 2:41 pm
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...
November 6, 2017 at 2:37 pm
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...
October 24, 2017 at 2:32 pm
How'd the install go? Are you happily running SQL 2008 R2 and 2016 on the same machine?
October 24, 2017 at 2:07 pm
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...
October 23, 2017 at 8:32 am
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...
October 20, 2017 at 4:33 pm
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...
October 20, 2017 at 4:18 pm
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...
October 20, 2017 at 3:51 pm
Yeah, I would agree with that.
My knowledge of the IT world comes because I worked in IT prior to moving to being a software developer (mostly web based) and...
October 20, 2017 at 2:24 pm
Viewing 15 posts - 2,251 through 2,265 (of 2,899 total)