Questions tagged [sql-server-2014]

Microsoft SQL Server 2014 is a version of the relational database management system designed by Microsoft, released on April 1, 2014.

Microsoft SQL Server 2014 was released on April 1, 2014, and brought with it some notable changes. They include but are not limited to:

  • New cardinality estimator
  • New In-Memory OLTP Engine
  • Enhanced Windows Server Integration
  • ...

For a full list of features, Microsoft supports and updates a comprehensive list of features, comparative to older versions of SQL Server.

The full list of editions has been updated as well in the latest version of SQL Server.
Currently they have three mainstream production editions:

  • Enterprise
  • Business Intelligence
  • Standard

A specialized edition in Web, and two breadth editions in Developer and Express.

70 questions
30
votes
1 answer

SQL Data-Tier Application - Export vs. Extract

What is the difference between the "Extract data-tier application" and "Export data-tier application" in the SSMS Options when right-clicking on a database?
CryptoJones
  • 824
  • 1
  • 9
  • 17
5
votes
1 answer

Where can I find End of Life Support Dates for Microsoft Products?

Specifically, I would like the the End of Life Support Dates for these: Windows Server 2012 R2 SQL Server 2014
Techboy
  • 1,540
  • 7
  • 31
  • 49
5
votes
2 answers

SQL Server 2014 SP1 installation failure - bug in SSIS_hotfix_install.sql

Installation of SQL Server 2014 SP1 fails if you have as SSIS Catalog on your server. After that, server does not start. Rebuilding system databases did not help (not sure, maybe because system databases were not actually corrupted, hence they were…
vaso
  • 103
  • 1
  • 6
4
votes
1 answer

Why am I getting "RESTORE DATABASE TERMINATED ABNORMALLY" (Error 3013) when restoring from Azure Blob Storage to SQL Server 2014

Our production database server is backing up its databases nightly to Azure Blob Storage, using the BACKUP TO URL command in SQL Server 2014 Standard. I'm now attempting to restore those backups to a new SQL Server VM we set up in Azure, which is…
Joshua Carmody
  • 175
  • 3
  • 9
3
votes
2 answers

Is there a performance overhead in having 2 instances of SQL Server 2014 running on the same VM

I have inherited an SQL Server 2014 which has been setup with 2 instances of SQL Server. Each instance hosts a number of databases and each instance has been setup to use all the CPU (4 processors) and RAM (32 GB). How does SQL Server manage this…
3
votes
1 answer

Sharing keys and certificates between SQL Server 2014 server for encrypted backup and restoration

I have six SQL Server 2014 servers. I am not using TDE, Transparent Data Encryption, on any server. I would like to be able to take an encrypted backup of a database on ANY server and restore that backup to ANY OTHER server. What actions do I…
3
votes
1 answer

Cannot connect to SQL Server Integration Services from SQL Server Management Studio: "Class Not Registered"

On a server running Windows Server 2012 R2 Datacenter, I have installed MS SQL Server 2014, using a very typical installation. On a Windows 7 client, I have installed SQL Server Management Studio 2016. I am able to connect to my SQL Server (as a…
Michael Plautz
  • 153
  • 1
  • 1
  • 7
3
votes
1 answer

OK to disable TLS1.0 with IIS and SQL Server 2014?

(This identical question in dba is drawing a blank) Background We need PCI-DSS compliance, and so must disable TLS1.0. In my test environment we have SQL Server 2014 SP1 with CU 1 (as per this post) and IIS 8 all on the same box. I used the Nartac…
2
votes
0 answers

Importing data from Informix DB to SQL Server

Configured Informix drivers (32-bit) ODBC on my local machine and trying to import the data to SQL Server using SQL Server IMPORT and export wizard. I selected source tables and views(steps in SQL import): When I click on preview I'm getting the…
2
votes
1 answer

Windows Backup / wbadmin errors | Source: SPP | Event id: 16389 | Increase SPP CreateTimeout?

After a reboot we encounter while the first backup (wbadmin) on a Windows Server 2016 these errors in the eventlog: Source: SPP Event ID 16389 Details: The writer's timeout expired between the Freeze and Thaw events (0x800423f2) Weak hardware…
2
votes
1 answer

Upgrading SQL Server (2014) Express to Standard

I have a server running SQL Server 2014 Express Edition that is fast approaching the 10GB limit for a database. I've now purchased SQL Server 2014 Standard and wish to use it. SQL Server is no longer available by boxed copy, so, I purchased it on…
William Hilsum
  • 3,506
  • 5
  • 28
  • 39
2
votes
0 answers

SQL Mirgations - Domain Trusts or not to Trust?

I am about to migrate something like 18 SQL servers into AWS from an on prem\colo. We will be building a new Domain in AWS and would like to leave the old domains behind. Do I need to setup a domain trust in order for my SQL servers to have no…
2
votes
1 answer

C:\Windows\System32\Config\systemprofile\desktop is unavailable

We are trying to set up Always On Availability Groups for SQL Server 2014 and we began with creating a cluster between two SQL Servers. Everything went fine until validating cluster creation and clicking on "Finish" button which suddenly led to this…
2
votes
0 answers

Kerberos Double Hop - SQL2014 HA - MSA's

OK, so i'm at my wits end. We have a system which works perfectly in our UAT environment (not HA) but will not work in live. so the config is: dns A record to iis box binding in iis on :80 to dnsname HTTP/dnsname SPN HA SQL 2014 cluster dynamic…
Dan
  • 138
  • 2
  • 11
2
votes
3 answers

Why do I keep getting Microsoft-Kernel-Power error and my 2012 R2 DataCenter is randomly restarting with this error

Microsoft-Kernel-Power error ID=41 on Windows Server 2012 R2 Data Center. My server went down twice yesterday due to this error happening, causing the server to restart on its own. This is an Azure VM. I checked the Device Manager and found nothing…
1
2 3 4 5