Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [sql-server-2008-r2]

SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

SQL Server 2008 R2 was released to manufacturing on April 21, 2010. SQL Server 2008 R2 adds certain features to SQL Server 2008 including a master data management system branded as Master Data Services, a central management of master data entities and hierarchies.

SQL Server 2008 R2 includes a number of new services, including PowerPivot for Excel and SharePoint, Master Data Services, StreamInsight, Report Builder 3.0, Reporting Services Add-in for SharePoint, a Data-tier function in Visual Studio that enables packaging of tiered databases as part of an application, and a SQL Server Utility named UC (Utility Control Point), part of AMSM (Application and Multi-Server Management) that is used to manage multiple SQL Servers.

The first SQL Server 2008 R2 service pack (Service Pack 1) was released on July 11, 2011.

390 questions
1
vote
0 answers

SQL Server Replication - How to connect to a system via computer name rather than IP address in Amazon AWS?

In Amazon AWS, VPC, I am trying to setup replication in SQL Server, and have three servers setup with port 1433 RDP open (1 web, two SQL). I can RDC into each server. From the web server, I can connect via SSMS to both SQL Servers by using the IP…
ElHaix
  • 269
  • 3
  • 13
1
vote
1 answer

Restoring database to a point in time not working

I have a database that is backed up nightly via a maintenance plan I created using the wizard in management studio. The recovery model is set to full. On the 26th something happened and SQL Agent was shut down (or maybe the computer was reset and…
BVernon
  • 403
  • 1
  • 7
  • 19
1
vote
0 answers

Losing connection to SQL Server on the same machine?

I've installed our SQL Server driven software on a client's computer. This consists of SQL Server 2008 R2 Express, and using ADO/SQLOLEDB drivers on a brand new Windows 8 64bit machine. The problem is periodically the application's connection to the…
Jerry Dodge
  • 147
  • 3
  • 14
1
vote
1 answer

ASP.NET Session State SQL Server 2008 R2 Freezes with High CPU Usage

Our ASP.Net website uses SQL Server as the session state provider. We currently host the database on SQL Server 2005 since it does not play well on 2008 R2. We would like to know why, and how to fix it. hardware setup Our current session state…
John Tseng
  • 155
  • 4
1
vote
1 answer

SQL server many to one mirroring

I have two SQL servers, server A and server B running SQL Server 2008 R2 Standard. Can I setup a third server that will be a mirror for both server A and server B? I can't seem to find any documentation stating that a many-to-one mirroring is…
Alex
  • 38
  • 3
1
vote
1 answer

TCP/IP connection to SQL Express works on HALF of the clients in a WORKGROUP

So far I have learned the following facts about Microsoft SQL Server Express, including version 2012, and earlier versions like 2008R2, and 2008, and for the most part all the way back to SQL Server 2005. I am configuring an SQL SERVER on a…
Warren P
  • 1,195
  • 8
  • 21
  • 35
1
vote
1 answer

SQL Server 2008 R2 on Windows Server 2003 - " failed to initialize 0x84B10001"

I am trying to install SQL Server 2008 R2 Express on Windows Server 2003 and I get an error "failed to initialize 0x84B10001". Googling got me the following link -…
user93353
  • 287
  • 1
  • 6
  • 17
1
vote
0 answers

SQL Server: Worse performance on a new server

We've been on a dedicated server (single quad-core, 6 GB RAM) and are moving to a new dedicated server (2x hex-core, 32 GB RAM). Both are Windows Server 2008, SQL Server 2008 R2. The performance on the new server is slightly worse than the old,…
Tim Westover
  • 133
  • 3
1
vote
1 answer

Troubleshooting I/O latency possibly caused by file system driver

I have a SQL Server instance (SQL Server 2008 R2, Windows 2008 R2) that complains, for very short, random periods of about 15-20 seconds, that some of its I/O requests are taking longer than 15 seconds. ("SQL Server has encountered x occurrence(s)…
Eldergriffon
  • 87
  • 1
  • 7
1
vote
1 answer

My php site cannot connect to SQL Database - SqlExpress2012

Im quite new to SQL Express 2012, but have just installed it on my server 2008 r2. Im trying to install a CMS called joomla, which I' ve done many times before both on SQL community server and hosted solutions. I can connect to sql server management…
Glen
  • 11
  • 3
1
vote
1 answer

SQL Server account disabled even in single user mode

I'm integrating with a third-party product via its SQL Server 2008 R2 database. In a previous version, I was able to access the database via SQL Server Management Studio and SQLCMD as a Windows administrator using Windows authentication. The…
Steve
  • 200
  • 2
  • 4
  • 13
1
vote
1 answer

How to enable Ad Hoc Distributed Queries in SQL Server 2008 R2

When I run a query with OPENROWSET in SQL Server 2000 it works. But the same query in SQL Server 2008 generates the following error: SQL Server blocked access to STATEMENT 'OpenRowset/OpenDatasource' of component 'Ad Hoc Distributed Queries'…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
1
vote
0 answers

SQL Server distribution agent cleanup job causes blocking

I am using SQL Server transactional replication, and have noticed that on a daily basis all of the publications for a distributor are being blocked when the distribution agent cleanup job executes. I have seen this block persist for up to 2 hours. …
Sean Fitzgerald
  • 11
  • 3
1
vote
1 answer

Error upgrading from SQL Server 2008 to SQL Server 2008 R2

I needed to restore a database (created in SQL Server 2008 R2 - version 10.50.1600) to a new DB in Server 2008 (version - 10.00.2531). I got the error - Restore failed for Server .... Additional info System.Data.SqlClient.SqlError: The database was…
CRoshanLG
  • 145
  • 1
  • 11
1
vote
1 answer

Will more memory help my CPU-peaking SQL Server 2008 R2

I'm supporting a system running against a SQL Server 2008 R2. The server is a single-CPU box with 8 GB of memory. As traffic has increased, the server has started saturating, peaking to 100% CPU ever more often. Disk I/O remains moderate (somewhat…
Tor Haugen
  • 449
  • 4
  • 6
  • 14
1 2 3
…
25 26