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
0
votes
1 answer

How do I upgrade sql server 2012 RTM to sql server 2012 SP1

I'm really confused by the 2 different editions of SQL Server 2012. There is RTM and SP1 which both seem like different code branches. How do I upgrade an RTM install to a SP1 install. I've tried upgrade and that doesn't let me choose the old RTM…
Terry Jones
  • 3
  • 1
  • 2
0
votes
1 answer

Automatic failover in SQL server alwayson availability group

I have 2 nodes in my SQL server fail over cluster. I use SQL server 2012 always on feature for HA purpose. The problem is that when one my server goes down the automatic fail over does not happen! How can I enable automatic fail over?
Pooya Yazdani
  • 277
  • 5
  • 12
0
votes
2 answers

SQL server databases are stucked in restoring state

I have a single server in my SharePoint 2010 server farm. Today some of users complained about that some of Infopath forms can not be opened. When I checked the SOL Server Management Studio I saw that some of my databases are in Restoring state as…
Pooya Yazdani
  • 277
  • 5
  • 12
0
votes
1 answer

TFS 2012 Backups w/DPM

I have a few servers running (mixture of 2012 and 2012 R2) and am playing with Microsoft's DPM as a backup solution. One of the things it complained about during installation was ensuring the SQL Server service I am configuring it to connect to…
Scott Salyer
  • 297
  • 4
  • 14
0
votes
2 answers

Does it change anything when I disable obsolete parameters in SQL Backups? SKIP , stats, Nounload , norewind etc

I am pretty new in managing Computersystems but I always want to know everything to get out the maximum. When we last time deployed a new version of our application I was given a backup script to backup a specific Database. I saw backup parameters…
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
0
votes
1 answer

sql error "Service Broker needs to access the master key in the Database "xxx" Master Key has to exist

I am pretty new to SQL and administration of databases and still learning. We receive one SQL error for quiete a long time, which has as far as we know no effect on our application. So we put that to second priority. Now it starts bothering me and I…
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
0
votes
2 answers

Possible to take a backup of SQL Server 2012 DB and restore on 2008?

I want to take a backup of SQL 2012 and restore on 2008, is that possible ? I have this options which I can't change on DB. Thank you
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
0
votes
2 answers

Just a few questions about Hyper-V virtual machines and clustering

I have been using Microsoft’s Hyper-V technology for a little while now, but I am just now dipping my toe into clustering. In particular, I am trying to implement a fault-tolerant SQL DB. This involves setting up two VMs, clustering them via…
René Kåbis
  • 107
  • 2
  • 3
  • 9
0
votes
1 answer

Error with SQL Server Setup 2012 on Windows 2012

I am trying to install SQL Server on Windows 2012. I was able to finally get the wizard up and running after making some changes on the server, but now it fails no matter what I do with the following error: TITLE: SQL Server Setup failure. SQL…
Jeff
  • 701
  • 8
  • 13
  • 26
0
votes
1 answer

After installing MS SQL Server 2012 not able to log into SSMS

Okay, lot's of posts around the internet on this subject. But I haven't been able to find an answer I was looking for. I installed SQLS 2012 on Windows Server 2012. I installed the Engine and the Reporting Server. In the Database Engine…
Martijn Burger
  • 445
  • 1
  • 5
  • 9
0
votes
1 answer

Microsoft Dynamics CRM 2011 + SQL Server 2012 database compatibility level

I know that Microsoft CRM 2011 is compatible with SQL Server 2012 since UR6 (UR10 for SP1). According to official documentation: During an upgrade or a new installation, Microsoft Dynamics CRM Server Setup sets the database compatibility level to…
Simon Carpentier
  • 3
  • 3
0
votes
1 answer

Windows Server and SQL Server Licenses

I have the following servers: PROD: 2 x web servers (content delivery) 1 x cms server 2 x database servers (SQL) UAT: 1 x web server (content delivery + cms) 1 x database server (SQL) I'm a bit confused with the SQL server 2012's User CAL…
ronanray
  • 113
  • 1
  • 5
0
votes
1 answer

Failing SQL Server Cluster installation, Addnode: Remote registry call failed

I'm adding a node to a SQL Server failover cluster. The installer throws the error "Addnode: Remote registry call failed. Unable to retrieve primary node Filestream settings" when adding node two TITLE: Microsoft SQL Server 2012 Service Pack 1…
Eric Herlitz
  • 588
  • 2
  • 9
  • 19
0
votes
1 answer

SSIS/ETL jobs fail with network related errors, when network is OK

We have a SQL Server 2012 instance that is our main ETL/DW server. The daily jobs consist of about 40+ ETL processes querying other data sources, updating the DataMart, standard ETL and BI processes. For the past several weeks, many jobs have failed…
Ddono25
  • 165
  • 3
  • 13
0
votes
1 answer

SQL Server 2012 Management Studio Connect after some time (File not found error)

I've a root server with Window Server 2008 R2 where MS SQL Server 2012 is installed. Get a error while connecting. Management Studio Error Message File not found This error only occur directly after start. Then i wait 2 Minutes. Everything is…
MR.ABC
  • 101
  • 2
1 2 3
…
17 18