Tag Info

New answers tagged

1

I have been asking the same question for several months and have also been unable to find a clear answer on the internet. Perhaps that means that I'm more concerned than I should be; perhaps I should not be doing database server maintenance... So I was forced to do this yesterday, and everything worked well. This is how I went about it: I upgraded the ...


2

Yes, you can simply stop one config server, upgrade and restart it. That is one of the reasons why there are three: even when taking down one, there are two others to read from, so one might fail. A few things to keep in mind, though: When one config server is down, the cluster meta data is read only: no chunk splits or migrations during that time. So in ...


4

This happens because the msdb log file name has been changed from the default which is "MSDBLog". In my case, it was called "msdb_log". The name "MSDBLog" is hard-coded into the upgrade script so it fails if the name has been changed. To fix the problem, we need to rename the log file to 'MSDBLog'. We have to start SQL with trace flag 902 to stop it from ...


2

ISSUE #1 : Upgrade Path Your grant tables can get screwed up because you are leaping two versions instead of one. I just helped someone a week ago because they did just that (MySQL service stops after trying to grant privileges to a user). The solution for that question was to manually fix the mysql.user. Rather than going through that heavy-handed route, ...


0

I am adding this answer as it could be helpful and related to Inplace upgarde First you need to check using the link Thomas gave whether inplace upgarde you are doing is supported or not. After you are sure you meet the upgrade matrix you can proceed with two considerations If you are upgrading from enterprise evaluation edition to enterprise you do not ...


2

Do you mean upgrade from Evaluation to the full Enterprise? If so, then yes that is supported. Take a look at the link here on BOL to show supported edition upgrades (scroll towards the bottom, it has SQL Server 2014 upgrades between editions and what's possible).



Top 50 recent answers are included