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

Unable to install SQL Server 2012

Unable to install SQL Server 2012 Error SQL Server Setup has encountered the following error: 1: 2229 2: Q:\PCUSOURCE\1033_ENU_LP\x86\setup\x86\sqlncli.msi 3: Property 4: SELECT Value FROM Property WHERE Property = 'ProductVersion'…
Prakash
  • 103
  • 1
-1
votes
1 answer

Cannot install Microsoft SQL Server 2012 prerequisites on Windows Server 2008 Core

I have the server with Windows Server 2008 core SP2 and I need to install SQL Server 2012 in it. The problem is that SQL Server requires .NET 4.5 and when I try to install .NET 4.5, the OS gives an error that says "the program is not recognized." To…
user202135
  • 7
  • 1
-1
votes
2 answers

SQL 2012 Server Database Transaction Replication performance issue

We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers. We had implemented transaction replication on to SQL-Node1 is working as…
Nirav Patel
  • 1
-1
votes
1 answer

SQL Server 2012 - No connection could be made because the target machine actively refused it

I've searched for the solution for this problem for days now, found a lot of stuff but none of it worked. I've got an SQL Server 2012 running on Windows Server 2012. I'm trying to connect to the SQL Server from a client computer remotely (with…
David Fenko
  • 1
  • 1
  • 1
-1
votes
1 answer

SQL Server 2012 memory usage steadily growing

I am very worried about the SQL Server 2012 Express instance on which my database is running: the SQL Server process memory usage is growing steadily (1.5GB after only 2 days working). The database is made of seven tables, each having a bigint…
pgmo
  • 1
-1
votes
1 answer

Licensing SQL Server 2012 Reporting Services w/ SharePoint 2010

Possible Duplicate: Can you help me with my software licensing issue? Here's my situation: I have 1 VM that is running SharePoint 2010 SP1. I have a different physical server that is running SQL Server 2008 R2 that hosts all the configuration and…
Evan M.
  • 842
  • 9
  • 16
-2
votes
1 answer

Cannot grant server roles to self using local DB SQL Server

I am not the admin on my work machine. I had SQL Server 2012 installed and I cannot create or import a DB. Under security I tried granting my windows UN 'dbcreator' and do not have permission. I log into my local server using my machine name.
Chris
  • 103
  • 1
-2
votes
1 answer

I need to fully automate sql server restores , PLease help me

I'm New to Sql server and dont have experience in automate restores I need a script to restore a database from a .bak file and move the logical_data and logical_log files to a specific path. I can do: restore filelistonly from…
DBA_Fresher
  • 1
-2
votes
1 answer

SQL 2012 Integration Services installation

Can you please suggest me the EXE to install SQL integration and Analysis services I have installed SQLEXPRADV_x64_ENU.exe, SQLEXPR_x64_ENU.exe from MSDN site.however, I could not find the integration services in my SQL SERVER configuration manager.
haritha
  • 1
-2
votes
1 answer

In MS SQL 2012 Database how to insert a very large table data in chunks

I need to archive large chunks of information in SQL Server 2012 by moving the data to a new table without blocking other users from using the original table. Is the best way to do this using a T-SQL loop statement, or is there a better way to do…
Lakshmi Kumar
  • 1
-2
votes
2 answers

Is it Safe to Install SQL Server 2012 on a machine which have SQL Server 2008 R2 running?

I am using SQL Server 2008 R2 quite a while. It is working great. Now I need to use SQL Server 2012. Will this effect my existing database. How much Risk involved in installing SQL Server 2012 on a machine that have SQL Server 2008 R2 running.
user960567
  • 329
  • 2
  • 9
  • 17
-3
votes
1 answer

Does SQL Server 2012 Developer Edition exist?

On my server, I have SQL Server 2008 R2 Developer Edition installed, and setup don't want to upgrade it to SQL Server 2012 Express. Does SQL Server 2012 Developer Edition exist?
abatishchev
  • 531
  • 1
  • 9
  • 31
-4
votes
1 answer

Is SQL Server 2012 Express Edition a Production Release? The download still has RC on the end

I though SQL Server 2012 Express Edition was "Released for Production", however when I download it, it still states "RC". Maybe I don't understand "RC" fully, but I though that was just before the production release?
TreK
  • 257
  • 1
  • 2
  • 7
1 2 3
…
17
18