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

Restarting MSSQLSERVER service on the principal or on the mirror the database is set in "In Recovery" mode

I'm running MSSQL Server 11.0.2100 (SQL Server 2012) and every time I restart the MSSQLSERVER service on the principal or on the mirror, the database mirror breaks and the database is set into In Recovery mode on the SQL instance that was…
Kalle
  • 121
  • 1
  • 7
0
votes
1 answer

SQL Server on Hyper-V on SQL Server 2012

I saw that this is the feature of AlwaysOn for SQL Server 2012. Can anyone explain the meaning of this? I mean can anyone give example or scenario? SQL Server on Hyper-V SQL Server instances hosted on Hyper-V environment get the additional benefit…
Alisa
  • 101
0
votes
1 answer

SQL Server 2012 using MSA -- SharePoint 2010 Powershell backups impossible?

I'm having trouble trying to do a simple backup of our 2-server SharePoint 2010 farm. I'm running the backup process with a Powershell command, backing up to a UNC shared folder on the SharePoint server. I have SP2010 on one server and SQL 2012 on…
Jeff Harris
  • 3
  • 1
0
votes
1 answer

Upgrading SQL Server 2000 to 2012

please is there any checklist available for upgrading SQL server 2000 to 2012? What is your experience with performing this? Could be the upgrade performed directly at all, or will I need to go through 2000 -> 2005 -> 2008 -> 2012? Thanks and…
Matej
  • 101
  • 1
0
votes
0 answers

Cannot log in to SQL 2012 - no known login

Possible Duplicate: How to recover a MSSQL user's password? We recently installed SQL 2012 on one of our servers, but have been unable to log in. Another tech did the installation so I don't have the details, but I suspect that he did not…
gillonba
  • 343
  • 1
  • 4
  • 16
0
votes
1 answer

Upgrading SQL Server 2008 to 2012

I have SQL Server 2008 running on my development machine that I wish to upgrade to the 2012 release. In your experience, is it better to use the upgrade wizard or to remove the SQL Server 2008 and do a clean install?
Dr. Greenthumb
  • 113
  • 2
0
votes
2 answers

SQL server agent job to execute SSIS package fails, package succeds if run manually

I've got a SSIS package installed on a SQL server (SQL Server 2012). It's fairly simple and just fetches data from a remote data source and adds it into a local table. The remote connection string is using SQL server authentication, while the local…
growse
  • 7,830
  • 11
  • 72
  • 114
0
votes
1 answer

Converting Sql Server 2012 RTM from trial to licensed edition

Similar questions have been asked about 2008, but there appears to be a dearth of information on SQL Server 2012. Does it require a reinstall? Will it go through an upgrade process (and what does that entail) or is it just a magic SKU switch? Is…
RichardTheKiwi
  • 205
  • 1
  • 6
  • 14
0
votes
1 answer

sqlcmd backup script failing

I'm trying to use a simple batch script to backup a local instance of SQL Express 2012, as follows: @echo off SET BACKUP_DIR=E:\BackupData SET SERVER=.\\sqlexpress set dom=%date:~0,2% set month=%date:~3,2% set year=%date:~6,4% set…
Bryan
  • 7,538
  • 15
  • 68
  • 92
0
votes
0 answers

SQL Server 2012 AAG not failing over in case of SQL Server crash/stop

I have created the following structure: Two hardware servers with Windows Server 2012R2 installed, SQL Server 2012R2 installed. Then Windows went fully updated and SQL Server was patched to SP4, current version is reported as 11.0.7493. WSFC formed…
Vesper
  • 754
  • 1
  • 9
  • 29
0
votes
0 answers

SQL Server 2012 Database engine failed to install everytime

I am trying to install SQL Server 2012 -64 bit in our dev server running Windows Server 2012. Everytime, Database engine fails to install. I've checked the event logs it shows. Operating system error 2(The system cannot find the file specified.)…
Kunal Basu
  • 1
-1
votes
1 answer

Sql server 2012 installation error

one of my friends is currently installing Sql server 2012 and she encountered at "shared features" step. At "Shared features" step, normal installation would give user to select Management tool -Basic Sql Client Connectivity SDK etc depending on…
Kyaw Zin Thant
  • 3
  • 1
-1
votes
3 answers

How do I move an entire SQL instance for SQL Server 2012 to a different server?

I tried this with SQL Server 2012, no joy: How can I copy a SQL Server 2008 instance to another server? SQL would not start on the target server it first complained about not being able to write to it's error log files and now it's complaining that…
Ted Mittelstaedt
  • 101
  • 1
  • 1
-1
votes
1 answer

WSUS refuse to install

Dears.. I hope you are doing well.. I am facing issue with WSUS. Actually, It was working fine and works with SCCM until an issue appears. So, I decided to reinstall WSUS, but I faced another problem.. when I specify DB instance and content path …
Mr. Ali
  • 35
  • 1
  • 1
  • 3
-1
votes
1 answer

What are my options to run MS SQL 2012 on Amazon RDS for development if I only have MSDN license?

I want to run MS SQL 2012 SE BYOL on Amazon RDS under my own MSDN license but it looks like MSDN license doesn't allow me to run MS SQL unless I host it on the dedicated hardware Microsoft Volume Licensing Product Use Rights (July 2014) states,…
kirill_l
  • 217
  • 3
  • 11
1 2 3
…
17
18