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

High CPU utilization on server

Server Configuration: Virtual Dedicated Windows Server 2008, Xeon Processor 1.6GHZ, 4GB RAM MS SQL Server R2 Express IIS 7.0 .NET Framework 4.0 Problem: Very slow response of the website due to HIGH CPU usage. Sometimes Site works…
user1562231
1
vote
2 answers

SQL Server 2008 R2 marked for unload due to memory pressure

I noticed the following error message on a development server that I'm working on. Can anyone tell me what this means? AppDomain 21 [mssqlsystemresource.sys[runtime].21] is marked for unload due to memory pressure
Evette
  • 11
  • 2
1
vote
1 answer

cannot connect to sql server express from sql server standard

... like my title says... I cannot connect to my instance on sql server express from sql server standard... I have tried disabling firing wall and checked sqlbrowser is started but for some reason I cannnot connect to my datbase... called…
EagleFox
  • 127
  • 8
1
vote
2 answers

Differential backup of new sql database fails until full backup is made

I have setup a job that runs every night and makes a full backup of all databases on the server. During the day, another job makes differential backups every few hours. The problem comes when a new database is created. The differential backup job…
Sir Code-A-Lot
  • 113
  • 4
1
vote
2 answers

Cannot install SQL Server 2008 R2 on Windows Server 2008 R2

We are attempting to install SQL Server 2008 R2 on a Windows 2008 R2 SP1 box. We keep running into errors at the end of the install - "the service did not respond to the start or control in a timely fashion". After that it shows "Failed" under…
charnley
  • 577
  • 3
  • 14
1
vote
3 answers

SQL Server returning empty result sets (to busy?)

My apologies from the start, I don't have much information to go on and I am just looking for some help debugging my issue. I have 5 sites running on a Windows Server Web Edition 2008 with SQL Server 2008 RC2 machine. Periodically on all sites (not…
webnoob
  • 465
  • 2
  • 16
  • 35
1
vote
1 answer

error when trying to load SQL server 2008 R2 native client x86

There's technically 2 problems interlinked with each other here... I'm currently working on connecting to a mssql database from a website and testing everything through Xampp on a VM. When running the code I get this error on the webpage: Array (…
hmmk
  • 13
  • 3
1
vote
1 answer

Clustering MSDTC on windows Server 2008 R2 returns "No storage Available"

I've set up a failover cluster, with SQL Server 2008r2, and it is running fine. I want to cluster MSDTC as well, but when I go through the high availability wizard, it tells me that there is no storage available. The storage node in the failover…
Jeremy
  • 913
  • 2
  • 10
  • 19
1
vote
3 answers

SQL 2008 R2 Named Instance Client Connectivity Issues?

We're upgrading our software from using SQL 2000 to 2008 R2. Our customers will be installing an update which uninstalls 2000 and installs 2008 R2 under the same instance. So if no instance existed, then no instance name will be set (default).…
Jerry Dodge
  • 147
  • 3
  • 14
1
vote
1 answer

Quorum Disk size for Windows 2008R2 failover

I am setting up a two node failover cluster for SQL Server 2008 R2 on Windows Server 2008 R2. Microsoft recommends minimum 512MB size LUN for the quorum disk and don't have a recommendation for the witness LUN. What do people typically run with…
bakesale
  • 149
  • 5
  • 13
1
vote
1 answer

Moving MS SQL Server installation files

I need to move the installation files for SQL Server 2008 R2 from where they currently reside (S:\Program Files...) to a new drive (yet to be created). My S: holds my SQL backups, active data files, and SQL Server program files. I have only one idea…
Chris76786777
  • 979
  • 5
  • 21
  • 35
1
vote
1 answer

Is start-process supported in a powershell step on SQL Server 2008 R2?

With the described configuration, I have a SQL Agent Job that includes a Powershell step. That step throws an error when it gets to the line $app = start-process -passthru $program $program_args saying - "The error information returned by…
Jeff Sacksteder
  • 927
  • 9
  • 15
1
vote
1 answer

SQL Server 2008 R2 GHOST CLEANUP hanging processes

2008 R2(SP1) - 10.50.2500.0 (X64) Hi, I am having the following problem intermittently on my development machine. I am running some T-SQL in a FOR loop. During each loop iteration, first we delete all rows in a table and then we add some rows to it…
MT.
  • 121
  • 4
1
vote
1 answer

Adding SQL Server 2008 R2 (sqlexpress) datasource in CF Administrator

I am using coldfusion 9 and SQL Server 2008 R2. It is set up as sqlexpress When I try to add a data source (sql) I get this error: Connection verification failed for data source: test_cursor java.sql.SQLNonTransientConnectionException:…
Didger
  • 11
  • 2
1
vote
1 answer

SQL Server 2008 service pack installation error

When I am trying to install the SQL Server 2008 service pack I am getting the error as: There are no SQL Server instances or shared features that can be updated on this computer, and The version of SQL Server instance Shared Component does not…
suganyag
1 2 3
…
25 26