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

SQL Server 2012 event ID 18487

Good morning guys. We have a SQL 2012 instance we use to store data on the parts we create. We have software that goes and pulls data out of the PLC on the machine and dumps the data into the SQL Database. We have not run the machine since…
Individual101
  • 63
  • 1
  • 3
  • 11
0
votes
2 answers

Publish-AXReport Gives Error "Name cannot begin with the ' ' character"

Running the below PowerShell script (i.e. to deploy all SSRS reports for AX) gives an error: $axdllname = "Microsoft.Dynamics.AX.Framework.Management.dll" $gacfolder = join-path $env:windir "assembly\GAC_MSIL" $axdll = Get-ChildItem $gacfolder…
JohnLBevan
  • 1,214
  • 7
  • 22
  • 46
0
votes
1 answer

Restoring a differential database file "the backup set holds a backup of a database other than the existing"

I am trying to test restoring a SQL database using a full/differential approach to a different server than it was backed up from. The database is in simple recovery mode as it is a test data warehouse. I've got a full backup which is roughly 5 days…
Lock
  • 1,637
  • 7
  • 26
  • 33
0
votes
1 answer

What is Best Practice for migrating SQL 2012 system databases to failover cluster?

What is the best practice for copying system databases when migrating from SQL Server 2012 (no SP) to 2012 SP2 in a Failover Cluster? Just backup and restore? Or, script out and script in?
Eric Loos
  • 31
  • 1
  • 5
0
votes
1 answer

IIS 8 with SSL Fails To Connect to Remote SQL Server

I have recently setup a new testing environment consisting of a load balancer routing HTTPS traffic to a single IIS 8 webserver (more will be added once I work through this issue). The IIS 8 webserver talks to a remote SQL server via an unencrypted…
husterk
  • 3
  • 2
0
votes
3 answers

Changes to data ordering between SQL Server 2000 and 2012

My company recently migrated a .NET 1.1/SQL Server 2000 web application to SQL Server 2012. We've had a couple of support calls relating to unusual behaviour - particularly with stored procedure queries without ORDER BY clauses. I appreciate having…
Spodgy
  • 103
  • 2
0
votes
1 answer

SQL Server 2012 Service not starting (Probably related to Service Agent issue)

I have an application (Dynamics AX 2012) that can't connect to the SQL server. I log onto the SQL server, and open SQL Server Management studio and can't connect to the database engine. I check the Sql Server configuration manager and all the…
Doug
  • 101
  • 1
0
votes
0 answers

SQL 2012 AlwaysOn Availability Groups Failover Successfully But Application Complains About Login Failed for User

I am trying to get SQL 2012 AlwaysOn Availability Groups working for an application. The cluster has 2 SQL nodes and 1 witness server. Everything appears to be failing over successfully when I do simple tests. Ex. Manual failover using SQL…
leeman24
  • 147
  • 1
  • 9
0
votes
1 answer

Install SQL Server 2012 to Windows Server 2008

I'm trying to install SQL Server 2012 in Windows Server 2008 R2 Standard Operating System. However this Error keep appearing even though I installed both .NET Framework 3.5.1 and 4.0 The operating system on this computer does not meet the minimum…
Voj
  • 3
  • 3
0
votes
1 answer

Does the amount of disks in a RAID10 matter for a Microsoft SQL server in regards of the block size?

We are planning to deploy a Microsoft SQL Server and to store the databases on a RAID10 (RAID1+0) block-level-storage. Does it matter how many drives altogether I put into the array for optimum operation? Be it four, as in the picture above, or six…
Daniel
  • 6,940
  • 6
  • 33
  • 64
0
votes
2 answers

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all assume that I want to use new features of 2012. But we…
KenavR
  • 101
  • 2
0
votes
1 answer

Slow merge replication over a WAN link - only downloads

We've been using SQL Server merge replication for a few years to synchronise data between our data centres, but we are now suffering with a big performance issue. This may be because the amount of data we are synchronising has increased a lot this…
Mark E
  • 1
0
votes
1 answer

How to attach a database created by sql 2008 to sql 2012 when full text catalog missing?

I have an already created mdf file which was created by sql server 2008.But when I attach this mdf file to sql server 2012 it asks me to add necessary full text catalogs. I have no idea what to do.Please help me.
karthik
  • 1
  • 1
0
votes
1 answer

Setting up Multi server environment in Sql Server 2012 - Enlist Failed Error

I am trying to Configure the Master target server / Multi server environment in Sql Server 2012. I changed : MSXENCryptChannnelOptions # Changed from 2 to 0 AllowDownloadedJobsToMatchProxyName # changed from 0 to 1 on the target When I run the…
user3325655
  • 101
  • 1
0
votes
2 answers

SQL Server: Upgrade CPU or add a second CPU?

Currently have a 2 socket server with a single xeon e5-2407 @2.2Ghz running SQL Server 2012. There are no performance issues at the moment but wondering for the future if it would be better to upgrade the existing CPU (higher clock speed, more…
Fahd
  • 9
  • 2
1 2 3
…
17 18