Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2012]

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is a version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 logo

Microsoft SQL Server 2012 (often abbreviated as SQL Server 2012 or MSSQL 2012) is the latest version of Microsoft's SQL database server software. It includes new features and upgraded functionality from its predecessor, SQL Server 2008 R2, went RTM on March 6th, 2012 and to general release on April 1st, 2012.

SQL Server 2012 is available in several "mainstream" editions, as well as some "special" editions not widely available for wide, such as a Development edition, an Azure edition and a Massively Parallel Processing Edition.

The mainstream editions are:

  • Enterprise Edition
  • Business Intelligence Edition
  • Standard Edition
  • Express Edition
  • Web Edition
  • Compact Edition

The complete feature set of SQL Server 2012 is massive, and probably too big to list, but Microsoft has a large page devoted to the topic, and includes feature comparison across the various mainstream editions. SQL Server 2012 adds new features focused on increasing the availability and scalability of the SQL Server product line, most notably a "AlwaysOn High Availability" feature, a dedicated Disaster Recovery feature, "scale-out reads" functionality and database mirroring capabilities.

268 questions
1
vote
2 answers

SQL 2012 Transaction Log backup does not truncate the logs

I'm a beginner in DB administration so bear with me. I have a small DB 500MB with a very large transaction log (19GB). I'd like to keep this in "Full Recovery" mode, so please do not suggest "Simple" recovery mode. I have been researching about how…
user2629636
  • 774
  • 5
  • 19
  • 40
1
vote
2 answers

Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2

I have been running SQL SERVER Express 2008 on Server 2012 R2 for some time. I recently began researching the migration process to move to SQL SERVER EPXRESS 2016. Because the original DB was migrated from Express 2005 the compatibility level was 90…
htm11h
  • 170
  • 11
1
vote
0 answers

[SQL Server Native Client 11.0]Unable to complete login process due to delay

We have one SQL Server 2012 Fail-over cluster instance where 11 database is running. Application is installed in different server. Application connects from application server to database server. Today application team informed us they got below…
Arif
  • 11
  • 2
1
vote
1 answer

How can I isolate data-warehouse workloads from production/on-demand queries?

I'm using VMware's vSphere 6 and I'm considering consolidating several SQL servers, these servers have different usage profiles; On-demand burst reporting (Cognos/Data-warehouse) Interactive web usage (Business hours/with variable peak usage) I…
makerofthings7
  • 8,911
  • 34
  • 121
  • 197
1
vote
1 answer

How do I configure the Windows Firewall to allow specific computers to connect to a SQL Server Instance?

I'm trying to allow only specific computers on my domain to connect to a SQL Server instance but I appear to be inadvertently blocking all computers from connecting. When I go in to configure the firewall on the server hosting the database, after…
Jake
  • 111
  • 1
  • 3
1
vote
0 answers

Windows Server 2008 R2 alias or Cname

On one of our client server, Windows Server 2008 R2 is installed. On the same machine, on SQL Server 2012, I am seeing 2 server names MHMSDB01 and user_DB1 are actually same server (IP address.) host name is MHMSDB01. But I have access to MHMSDB01…
Coder157
  • 11
  • 1
1
vote
0 answers

Strange error in SQL Server from ASP.NET app

I posted this question on stack overflow, but to no avail. Getting desperate here. So we have an extremely random error (by which I mean, there appears to be no usage pattern that precedes the error) in our C# ASP.NET MVC5 application, that occurs…
barnacle.m
  • 121
  • 4
1
vote
1 answer

I'm getting a warning that disk space on C: is below 5% when it's not

It's a database server running SQL Server 2012 on Windows Server 2012 R2. C: is the boot/windows drive, but does NOT contain the data (mdf), log (ldf), or temp files (tempdb.mdf) for the database. So it's not any of those growing and shrinking…
MGOwen
  • 307
  • 2
  • 4
  • 11
1
vote
2 answers

SQL Server express - Management studio installation hangs at native images installation

I've been trying to install SQL server express edition (2014) with management studio and consistently failing to do so because installation stalls at step 'Install_sql_common_core_Cpu64_Action : Write_NativeImage_64. Generating Native images'. I've…
JayaprakashReddy
  • 107
  • 1
  • 6
1
vote
2 answers

SQL Server 2012 support for TLS 1.2, 2 downloads, Which One?

If you disable TLS 1.0 and SSL 3.0 for PCI, SQL Server will stop working. SQL Server 2012 r2 out-of-the-box only supports SSL protocols up to and including TLS 1.0 by default. Unfortunately, PCI has required the obsolescence of SSL 3.0 and TLS 1.0.…
Michael Barber
  • 165
  • 2
  • 3
  • 10
1
vote
1 answer

Why are SQL Backups slower on Server OS?

We are a hardware and software provider to small government agencies, where many offices have just 1-3 computers, with a few others that are bigger having 5-12 workstations. For the small offices we set them up with a Win7 based peer to peer…
Mark Dynna
  • 151
  • 3
1
vote
1 answer

Azure network latency between VM and Cloud Service

We have recently setup a virtual network that consists of one virtual machine (A3) running MSSQL, and one cloud service (Medium) running a web role. Our web role will connect to the database using the internal network IP which works fine. The issue…
user1005344
  • 13
  • 4
1
vote
1 answer

In SQL Server 2012 Failover Clustering, we are getting "The action 'Move' did not complete. Error Code: 0x80071398"

We have setup 2 VM Nodes for SQL Server 2012 Failover Clustering. The iSCSI drives are on our SAN. Cluster setup and SQL Server 2012 SP2 install succeeded without errors. Connecting to SQL Server from Management Studio remotely works to create a…
Eric Loos
  • 31
  • 1
  • 5
1
vote
1 answer

Latency & SQL Connections over Fiber WAN - Application E-manage

I am hosting an encrypted SQL server database (SQL Server 2012) on a VMware host at my Salt Lake location. My Salt Lake data pipe is 100 Mbps over fiber via Comcast. My Phoenix side has a 50 Mbps over fiber via Cox. My latency between sites is 45…
troyB
  • 13
  • 3
1
vote
2 answers

Can't connect after NEW Install SQL Server 2012 on Win 7 Pro SP1 with Windows Auth or SQL Server Auth

Trying to install SQL Server 2012 (Eval) to work with the new BI tools using AdventureWorksDW tutorial. Therefore, I feel I've gotten bogged down in SA activities that would be done by others in the real world. I need help to get 2012 running. What…
David Eiland
  • 11
  • 1
1 2 3
…
17 18