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
2
votes
2 answers

SQL Server 2012 Maintenance Plan succeeds but does not perform backup

I have a new SQL Server 2012 AlwaysOn Availability Group on Windows Server 2008 R2 Ent SP1. I'm creating a Maintenance Plan on the Primary Replica which is supposed to do Full (non-copy-only) backups of the only User database. The task is…
Sheree
  • 51
  • 1
  • 4
2
votes
1 answer

SQL Server 2012 Mirroring / AlwaysOn - need for SAN?

There appears to be a great deal of conflicting information about whether or not SAN is required for a Sql Server 2012 Mirroring setup. I currently have an Active-Passive-Witness SQL 2008R2 setup where each of the machines in the setup have plain…
Kenny
  • 520
  • 1
  • 9
  • 24
2
votes
1 answer

Can an instance of amazon ec2 be upgraded automatically from sql server 2008 r2 to sql server 2012?

Is there a tool from Amazon or Microsoft to automatically upgrade an ec2 instance's sql server 2008 to 2012? Or do I have to create a new instance and then import all the databases?
Robert Louis Murphy
  • 165
  • 1
  • 8
2
votes
1 answer

Cannot log in to SSRS 2012 using any account

I have installed SQL Sever 2012 along with Reporting Services. I have configured Reporting Services using the Reporting Services Configuration Manager. It seems like the service is running properly, however I am unable to log in to it using any…
Xavier
  • 269
  • 3
  • 9
2
votes
1 answer

What are the exact storage requirements for an AlwaysOn implementation?

We're investigating implementation options for SQL Server AlwaysOn. AlwaysOn is dependant on Windows Clustering, and I have read several articles that state shared storage is no longer a requirement for clustering. I have also read several articles…
Samantha Branham
  • 221
  • 3
  • 11
2
votes
1 answer

Issue installing a SQL Security Update on Windows Server 2012 R2

We're having a weird issue with the "Security Update for SQL Server 2012 Service Pack 4 CU (KB4583465)" update on one of our servers. It will show as installing successfully, but then after a reboot it shows as pending again. It shows every time it…
Harrison
  • 23
  • 4
1
vote
0 answers

Using AlwasyOn Failover Cluster Instance in conjunction of Peer to Peer Transactional Replicaiton

We are deploying two physical sites each with writable/readable access to its local SQL server. Each site has site redundancy and also cross site synchronization is required. My thought is to use the AlwaysOn Failover Cluster instance to achieve…
MidTierDeveloper
  • 49
  • 1
  • 5
1
vote
1 answer

Restore incorrect syntax near 'dbname'

I'm trying to restore a db to a new location, using the following in SQL Server Management Studio for Server2012: RESTORE [newdb-name] FROM DISK = '..\backupfile.bak' WITH MOVE 'olddb-name.mdf' to '...\newdb-name.mdf', MOVE 'olddb-name_log.ldf' to…
whybull
  • 13
  • 3
1
vote
0 answers

Sql Server Analysis Services won't start after reboot

Had to restart a server running SQL Server and SQL Server Analysis Services. (The reboot was related to the Hyper-V Host it was running on.) The SQL service works fine, but the SSAS refuses to start. Checking the log and Event Viewer, the following…
Andreas
  • 309
  • 1
  • 5
  • 17
1
vote
1 answer

Windows 2012 Server inaccessible (using rdp) but SQL Server databases are accessible (ssms)

We have a Windows Server 2012 Standard, which runs SQL Server 2012 Enterprise edition. This morning we found the reporting services was inaccessible. We attempted to use Remote Desktop to connect to the machine, but could not get in. All databases…
kevcri
  • 11
  • 1
1
vote
1 answer

SQL Server slow in guest machine over time (virtualization with KVM on a Centos 7 Host)

We have a new server a HP DL360, 64GB RAM, 2x8 core CPU, SAS HDD Raid1 array and one SSD Raid1 array. The SSD Array is configured with 2 Samsung 850 Pro devices (not HP certified). We installed a Centos 7 OS as a Host OS and we have only one VM…
Enovator
  • 31
  • 1
  • 6
1
vote
1 answer

Hyper-V Host, with Windows SQL Server 2012, Boot Failed

This question has been asked plenty, but none of them resolve the issue for me. I have a hypervisor (Hyper-V 2012). When I go to add a new VM from this .iso, which is the Microsoft SQL Server 2012 Evaluation. When I create a new VM, and make it a…
trueCamelType
  • 1,086
  • 5
  • 20
  • 42
1
vote
0 answers

For SQL server with one User CAL, can one user be logged in concurrently from multiple devices?

So basically our client had no idea what they were doing when licensing SQL Server, and ended up only purchasing one User CAL. What I'm wondering is, can that same User CAL be used across multiple devices using the same login, so that only one user…
Nerdrave87
  • 11
  • 1
1
vote
2 answers

SSRS-error about report server database version after hotfixing SQL. The found version is '164'. The expected version is '163'

After applying hotfix KB3194725 to our SQL server, the SSRS server throws the following exception when trying to generate a report: Exception type: InvalidReportServerDatabaseException Exception message: The version of the report server…
Henrik H
  • 111
  • 1
  • 4
1
vote
1 answer

SQL Server 2012 constant CPU load

I'm trying to diagnose an abnormal CPU usage of the sqlservr.exe process from a SQL Server 2012 Express installation. The installation is running in a VM with Windows Server 2012 R2, 8-core Xeon E5 and 8GB of RAM. The CPU load (from both…
tsmr
  • 11
  • 2
1 2 3
…
17 18