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
0 answers

SQL Server Chain Permission

We have the 2 databases. Reporting HR There are some users who want to extract data from HR database. But we don't want to give direct access to that HR database. So, we created the special views in Reporting database and the users have dbowner…
TTCG
  • 121
  • 1
  • 3
0
votes
1 answer

TFS Database migration miss the detach step issue

We currently doing the TFS database migration, originally, we suppose to upgrade to 2012 which support SQL 2008 R2, after a period of time, we decide to upgrade to 2013, and unfortunately we are upgrade on the rush and forget forget to detach the…
Jian_H
  • 11
  • 1
0
votes
2 answers

Windows Server Failover Clustering with two servers

I was going to create a Windows Server Failover Cluster, in order to set up MS SQL Server AlwaysOn Availability Groups. As a prerequisite of failover clustering, I've created and configured an Active Directory using two servers. One server is…
Jack
  • 113
  • 1
  • 2
0
votes
1 answer

prevent replace sql database files with old one

i have a database that i use in my application. the operation i want to prevent is if i stop sql server and take the database files to another location then start the sql server and make some operations then stop the sql server services and replace…
امير طارق
  • 5
  • 3
0
votes
0 answers

What happens on an SQL Server when a snapshot is taken by VMWare?

Recently I saw in our SQL Server logs that a snapshot could not be taken at the specific time and he retried it later on. During that timespan we had a huge performance problem. Besides the SQL Server we have some files there as well, this will be…
RayofCommand
  • 1,451
  • 8
  • 26
  • 36
0
votes
1 answer

Exporting a Subset of Data in Microsoft SQL Server to Script

We are running a Microsoft 2012 SQL Server and are looking at a way to dump a subset of data (based on queries) to .sql scripts we could then run on another server to pull that data back in. We have an environment where we have a production server…
Jason C
  • 3
  • 3
0
votes
1 answer

sql web replication ?diag errors

Trying to configure web replication, and running into a number of issues. When running replisapi.dll?Diag, I receive the following errors: CLSID_SQLReplErrors FAILED 0x80040154 replrec.dll classes FAILED 0x80040154 I tried copying replrec.dll…
Brad
  • 165
  • 9
0
votes
1 answer

SQL Server 2012 Express - silent installation.

I am failing to silently install SQL Server 2012 Express (Advanced). I followed the guidance and this is my command: Setup.exe /q /ACTION=Install /FEATURES=SQL,Tools /INSTANCENAME=MSSQLSERVER /SQLSVCACCOUNT="MyDomain\Coduy"…
Okrx
  • 73
  • 1
  • 12
0
votes
2 answers

SQL Server 2012 which user is using Memory and CPU

For sql server 2012 I am looking for a way to see which active user logins are using how much memory and cpu. I have done a search but it seems there is only a way to see aggregates or how much each database uses for memory. Any help would be…
Xaxum
  • 317
  • 1
  • 6
  • 16
0
votes
1 answer

What happens when Core Cluster Group is failed over to another node? Will it take the whole cluster down? Single point of failure?

http://bit.ly/1lKJFIa "Cluster group" fail-over will cause cluster go offline. Really? Single point of failure? Am I missing something? What happens when Core Cluster resources (Cluster Group) are failed over from one node to another? Will it take…
Bamboo Shoot
  • 11
  • 4
0
votes
1 answer

migrate plus move existing biztalk server database from sql server 2008 R2 to sql server 2012

we are planning to move biztalk database from one place to another as well as upgrade the sql server. the initial database is in sql server 2008 R2 and target is sql server 2012. but the thing is that we have to set up database on another system, i…
sameer
  • 1
  • 3
0
votes
0 answers

Unintended SQL Server 2008 Express instance installed

I installed SQL Server 2008 R2 Expess with an instance name SQLX08, then I installed SQL Server 2012 Expess with an instance name SQLX12. Now in the SQL Server Configuration Manager I see, along with these 2 instances, another instance named…
atiyar
  • 133
  • 2
  • 8
0
votes
1 answer

SQL Server database backup to Windows Azure Recovery Service

I have some VMs on Windows Azure and IIS and SQL Server 2012 is installed on them. I also created a Backup Vault on Windows Azure and installed the Windows Azure Backup Agent on the VMs. It works well to backup the websites but not the…
Cloudlucky
  • 31
  • 4
0
votes
2 answers

SQL Server 2012 Reporting Services to export CSV

I have an SQL Server 2012 Reporting Services instance, and by default, it can only export to PDF, Excel and Word. Users require CSV export as well. All I found is that there are different extensions, but not clear how to add or install them. This is…
Adam Szabo
  • 121
  • 1
  • 7
0
votes
1 answer

How can I get SQL 2012 Web Edition?

If I want to get a copy of SQL 2012 Web Edition, do I have to go through a hosting provider such as Rackspace? What about if I am in the MS Select program and a Volume Licensing account? How is it licensed? Is it also a per core license? Also, can I…
blizz
  • 1,134
  • 1
  • 26
  • 47
1 2 3
…
17 18