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

Server 2008 R2 Replication Small Issue

I have two 2008 R2 Servers. When I Connect those two Servers By Name, I Can Use Replication. But When I Connect This Two Servers By IP Address, I Can't Use Replication. I Get Error Like: SQL Server Replication Requires The Actual Server…
Rohit Tarang
  • 1
  • 1
0
votes
0 answers

Trying to determine cause of cluster failover

SQL Server 2012 running on a Windows 2012 Failover Cluster Instance. (**The cluster contains only a single node. Yes, I know that's terrible. No, it wasn't my decision....) The issue is that at seemingly random times overnight (our period of…
Bob Pusateri
  • 121
  • 4
0
votes
1 answer

SQL 2012 Restore Issue - Exclusive Access cannot be obtained

Situation - We have a Live_db database, and a Test_db database. I'm trying to Take a copy of Live to use as Test. A Backup of Live was taken. The existing Test database was deleted (closing existing connections) as we needed no data from it. I am…
SysAdminUK
  • 113
  • 1
  • 2
  • 14
0
votes
1 answer

Why are SQL Server 2012 tokens are not expanding when used in agent jobs?

I am trying to use tokens in my SQL Server agent jobs as described here, but some of the tokens are not working as I expect. When running an agent job, the tokens which are supposed to expand to provide information such as database name, server…
barbecue
  • 352
  • 1
  • 15
0
votes
1 answer

Vmware Site Recovery Manager Bubble network with SQL Server

We are trying to test an application that uses sql server 2012 in a bubble network with vmware site recovery manager. This means when we test the replication the servers are on a vlan that can't connect to anything but themselves. One of the…
Stephen Jesse
  • 13
  • 3
0
votes
1 answer

Why is SSIS reading so much data from my hard drive?

We're running SQL Server 2012 on Windows Server 2008 R2 for a our CRM and ERP services. Unfortunately, the majority of the setup was outsourced to an "expert" company who neglected to provide any documentation. For this and various other reasons,…
HorusKol
  • 751
  • 5
  • 13
  • 31
0
votes
1 answer

SQL Server 2012 Copy Database for Test DB fails

I'm trying to copy a database from our live system to the test system. (same Server, different DB) The Test DB has been deleted in preparation so we have a clean slate. I've tried backing up the DB, then restoring it but it fails saying it doesn't…
SysAdminUK
  • 113
  • 1
  • 2
  • 14
0
votes
0 answers

Virtual machine snapshot fails, followed by a hung server

We've had a rather annoying incident yesterday. During a routine snapshot backup, a machine failed with the following error: Backup virtual machine Cannot complete the operation. See the event log for details. Incremental Forever -…
Reaces
  • 5,597
  • 4
  • 38
  • 46
0
votes
1 answer

Ubuntu - SQL Server 2012 - Microsoft ODBC Driver 13 - Error: 18456, Severity: 14, State: 8

I have been attempting to get "Microsoft ODBC Driver 13 for SQL Server" running in Ubuntu for two days now, and I am out of ideas / have exhausted Google. My test machine is a vagrant VM, and these are the relevant pieces of the bash script that is…
David
  • 13
  • 4
0
votes
1 answer

Should I continue to use MSDTC in my new virtual environment for MSSQL?

In the past I have used a two node cluster setup. All the services (SQL, File Server, App Server, DTC) were passed back and forth within the cluster as normal. Now I take a different approach. I like to build my 2 node cluster and ONLY install the…
Arvo Bowen
  • 805
  • 5
  • 17
  • 35
0
votes
1 answer

MS SQL replication run only with system account

I'm trying to configure a new replication with SQL Server 2012 I configured the distribution While configuring the publication, it asked for a user to run the snapshot agent. I set a strong user with the right permissions to the snapshot…
abovebeyond15
  • 3
  • 1
  • 4
0
votes
2 answers

Install WSUS with remote SQL on port different to default

How do I specify the connection parameter to a remote MSSQL Server during WSUS setup that's default instance is not running on the default port?
Hupfauer
  • 181
  • 1
  • 1
  • 10
0
votes
0 answers

SQL Server Management Studio 2012 DB Backup script

I have SQL Server Management Studio 2012 installed on a VM. We have an active DB (attached to an ASP.Net application whose target Framework is 4.0). What I was looking for is a script to backup a DB that I can attach to Task Scheduler to take backup…
Yash Saraiya
  • 103
  • 6
0
votes
2 answers

Unable to start SQL server agent automatically

I am working on SQL 2012, I already been set up my SQL server agent in automatic start up mode in windows services as well in SQL config. Even though it was not starting automatically. How can I fix this?
Damodara Lanka
  • 101
  • 1
0
votes
2 answers

Sql Express 2012 Upgrade to SP1

I have Sql Server Express 2012 installed on one server. As I'm trying to install TFS 2015 and it require Sql Express 2012 with SP1 I would like just to update my instance to SP1, but I can't find a way. From MS website I see this (at this…
user449689
  • 103
  • 5
1 2 3
…
17 18