All Questions
Tagged with upgrade sql-server-2014
25 questions
1
vote
1
answer
7k
views
Cannot resolve the collation conflict between "Latin1_General_CI_AS" and "SQL_Latin1_General_CP1_CI_AS" in the equal to operation
Need urgent help on this. We have applied latest sql patches on one of the server (SQL 2014, SP3, CU4) and somehow we were not able to start the SQL due to following error.
Cannot resolve the ...
- 17
1
vote
1
answer
3k
views
Unable to start SQL Server Integration Services 12.0 service (SQL Server 2014) after upgrade to SQL Server 2019 and patched to CU4
I upgraded a SQL Server 2014 Standard instance to SQL Server 2019 Standard (also required upgrading the OS from Windows Server 2012 R2 to Windows Server 2019), and then patched to CU4.
During the SQL ...
1
vote
1
answer
24
views
In place upgrade from Express 2005 SP 4 to Express 2014, does database size limitation follow?
We are currently attempting get around a file size limitation issue with our database. The database file size hovers around the 4GB mark (the database size limit is 4GB in SQL Express 2005). We always ...
0
votes
1
answer
40
views
Upgrading Microsoft SQL 2014 and Always On AG Configurations
I'm getting ready to perform an upgrade from SQL 2014 to 2017 on two servers that are configured for Always On. The concern on the upgrade is how to break Always On to stop replication and to keep any ...
- 47
2
votes
2
answers
366
views
Upgrade in-place with low disk space on C: drive
I am due to upgrade SQL Server 2005 Express to 2014 Express. This will be an in-place upgrade.
It's not my preferred way of upgrading, but being a physical machine and in a specific secure network ...
- 193
3
votes
1
answer
415
views
SQL Server Patch Level Is Inaccurate, Causing Upgrade Issues
I have a box that lists SQL Server 2014 SP2 (12.2.5000) in both add/remove programs and the registry
HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Microsoft SQL
Server\120\SQLServer2014\CurrentVersion\...
11
votes
1
answer
476
views
SQLServer Upgrade Advisor 2014 hanging
I try to run SQL Server Upgrade Advisor 2014 against a SQL Server 2008 server.
Everything looks fine when connecting to the 2008 server and I can select which database I would like to analyze.
But ...
- 1,931
4
votes
2
answers
2k
views
Rebuilding large columnstore indexed tables - am I doing it right?
We are planning to move the database from SQL 2014 ENT into 2016 ENT.
We realized the data currently in columnstore table are not aligned in time when they are loaded, so we need to re-align the data.
...
- 223
1
vote
4
answers
8k
views
Removing older components after upgrading
I will upgrade to SQL Server 2016 from a SQL Server 2014 in my company.
This server has had many versions of SQL Server (2008, 2012, etc).
What should we do with the old version's components? When a ...
- 11
2
votes
1
answer
612
views
How to upgrade SQL Server 2008 to SQL Server 2014 servers with mirroring configured
We have two SQL Server 2008 R2 instances with mirroring configured. We want to upgrade them to SQL server 2014.
How will this upgrade effect the mirroring between the servers, and also how should I ...
4
votes
1
answer
1k
views
Index rebuild after SQL Server upgrade to 2014
The company I work for decided to upgrade the database engine from SQL Server 2005 to SQL Server 2014, the database is big and uses multiple files, and each table has a complex set of indexes to ...
- 175
2
votes
2
answers
204
views
Ingredients for SQL Server Version decision [duplicate]
We are going the create our Sql-Servers new on new hardware / VM's and think about which Sql-Server Version to go with. We are actually using Sql Server 2008 R2. We have already done a project for ...
- 4,807
2
votes
0
answers
5k
views
Full-text upgrade option to select during SQL Server in-place upgrade
What Full-text upgrade option should be selected ideally while doing SQL Server in-place upgrade? The Full-text Upgrade screen provides three Full-Text upgrade options (import, rebuild and reset). ...
- 1,928
8
votes
1
answer
2k
views
Recommended ways to upgrade AlwaysOn AG from 2014 to 2016
What is the recommended process of upgrading Availability Groups with one Sync Replica from SQL 2014 to 2016?
My understanding is that in-place upgrades are not really liked among database ...
- 183
1
vote
2
answers
4k
views
Upgrade a database from SQL Server 2000 to SQL Server 2014
I have database in SQL Server 2008 R2. I took a backup of this database and restored that on a SQL Server 2014 server. However, some of the database queries are not looking compatible to the new ...
- 133
3
votes
1
answer
357
views
Geography data type and Upgrading from 2008 r2 to SQLServer 2014
I am getting a warning about a data type called geography.
Our system has 1 column of data type geography. I am trying to figure out if the upgrade will fail or just if an app may have an issue.
...
- 79
0
votes
2
answers
120
views
A good way to verify if the update has no problems?
I don't know if this is a stupid question, but I'm upgrading my test instances to SQL Server 2014. I've installed SP1, after I will install Cumulative Updates.
It's working fine, but is there a way ...
- 7,484
2
votes
0
answers
79
views
Upgrade cluster sql server 2014
How can I upgrade SQL Server cluster 2012 to SQL Server 2014? Version – Standard. We have 2 nodes and 2 instances on each node. Have you manuals for upgrade 2 instances on cluster SQL Server 2014
We ...
0
votes
1
answer
76
views
What are the low hanging fruits of a SQL Server 2014 migration?
I have read about new features and changes of the SQL Server 2014 version. But I still don't know the benefits every server will have by upgrading (from 2008 R2) to 2014?
Are there any new features /...
- 4,807
-1
votes
1
answer
480
views
Upgrade from SQL Server 2008 R2 SP2 to SQL Server 2014 Error
I am upgrading from SQL Server 2008 R2 SP2 to SQL Server 2014 and receiving an error I cannot get past. Everything checks out before the upgrade runs.
The upgrade stops at ...
Pat
6
votes
2
answers
6k
views
Reporting Service 2014 Service Pack 1 Failing to work with error - wrong database version
Tonight we upgraded our SQL Server 2012 (SP2+CU6) cluster with SQL Server 2014 Service Pack 1.
On that cluster nodes, we have Native mode Reporting Services scale-out configuration.
After in-place ...
- 223
5
votes
1
answer
17k
views
SQL Server performance is slow when migrated from SQL Server 2012 to SQL Server 2014 [duplicate]
We are trying to migrate from SQL Server 2012 to SQL Server 2014 on Windows 2012 R2 OS.
After the upgrade, we are doing performance testing and observed huge difference in running a simple query from ...
Gopi Srinivas Thutaram
1
vote
2
answers
137
views
Upgrade BI server to 2014 and stay on 2008r2 with the database engine server
We would be happy to upgrade our SQL Server environments to 2014, but we have a tight budget for next year.
Our BI server (SQL Server 2008 Standard Edition, that is used only for BI purposes) is ...
- 575
8
votes
2
answers
14k
views
Can SQL Server 2014 Standard Edition Trial be upgraded to a full Core license?
If I install a copy of SQL Server 2014 Standard Trial edition can that version be upgraded (in place without a full re-install) to the full version (core license) afterwards? I'd love to get this ...
- 405
3
votes
2
answers
4k
views
Upgraded from SQL Server 2008 R2 Express to SQL Server 2014
I've upgraded my SQL Server from the 2008 R2 Express edition to a full standard version of SQL Server 2014. Now I'm running them both side by side. But my problem is how can I abandon the 2008 version ...
- 33