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

Running SQL Server 2008 with an Equallogic PS-series

Possible Duplicate: Anyone have any experience with SQL over iSCSI on Equallogic boxes? We've currently got a dedicated Microsoft SQL Server 2008 R2 server that's quickly running out of disk space. The server is hammered 24/7 pretty much and…
Mark Henderson
  • 68,823
  • 31
  • 180
  • 259
2
votes
2 answers

SQL 2008 to 2008 R2 upgrade failed, can't install R2 now

We attempted to upgrade SQL 2008 to 2008 R2. It passed the checks with flying colors. But midway through the installation we got the dreaded "No mapping between account names and Security IDs was done" error. After much Googling, we believe we…
Boo
2
votes
2 answers

Cannot Delete SQL Server Database via Command Line Executable

When running a command line executable, one of the tasks is to drop a database. When this gets run, SQL Server tells me that 'DBName' does not exist or you do not have permission. The database is confirmed to exist. At this point in the script, it…
Scott
  • 137
  • 1
  • 1
  • 9
2
votes
4 answers

Is Sql Server 2008 R2 unsupported by Operations Manager (SCOM) 2007 R2?

I'm performing a test configuration of System Center Operations Manager 2007 R2, on a system prepared with Sql Server 2008 R2. Unfortunately, the Scom 2007 R2 prerequisites verification program seems to be detecting exact versions of Sql Server, and…
bwerks
  • 752
  • 3
  • 10
  • 22
1
vote
0 answers

MS SQL 2008R2 Peer-to-Peer replication Zombie data

We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This replication has been running like a champ for more…
RemonsterGrrr
  • 11
  • 1
1
vote
0 answers

SQL Merge Replication Triggers Missing

In MS SQL Server 2008R2 SP3 Standard, I'm seeing an issue where reinitializing a merge publication with a new snapshot deletes all of the merge triggers from all of the tables, and then when snapshot creation happens does not restore them. At that…
Jason
  • 58
  • 8
1
vote
2 answers

Issue installing SQL SERVER EXPR 2012/2016 on Server 2012 R2

I have been running SQL SERVER Express 2008 on Server 2012 R2 for some time. I recently began researching the migration process to move to SQL SERVER EPXRESS 2016. Because the original DB was migrated from Express 2005 the compatibility level was 90…
htm11h
  • 170
  • 11
1
vote
1 answer

MS Native SQL driver 10.0 and SQL Server 2008 connection creation failure

I'm trying to narrow down and debug quite elusive error: State: 08001 Code: 258 Msg: [Microsoft][SQL Server Native Client 10.0]TCP Provider: Timeout error [258]. State: HYT00 Code: 0 Msg: [Microsoft][SQL Server Native Client 10.0]Login timeout…
przemo_li
  • 61
  • 4
1
vote
0 answers

Issues identifying SPNs

Background We are performing a server move. In the process, new servers and service accounts have been created. I'm getting two issues which I think are related to SPN's: I've created some SQL Linked servers (using 'current security context', i.e.…
Nick.Mc
  • 155
  • 1
  • 2
  • 14
1
vote
1 answer

MS SQL Server 2008 R2 database is in suspect mode

I have an database on MS SQL Server 2008 R2, which is currently showing principle, Disconnected / suspect. I have tried, to set DB in emergency mode but got failed and showing message database is in mirroring session. Anyone know how to resolve it?
user1372488
  • 121
  • 1
  • 1
  • 9
1
vote
0 answers

Server 2008 R2 permissions not working

First of all: i posted this yesterday but put in the wrong email so I can't access it again. I am configuring a 2008 R2 server for learning experience. The problem I'm having is the following: Current situation: I created 5 Users, put the users in a…
Pepito123
  • 11
  • 2
1
vote
1 answer

2K8 Cluster - SQL Instance broken on one node

Using a 2-nodes cluster 2008R2 Failover Cluster. A new clustered instance was created (I double checked it's clustered). Instance was installed on node1. When we try to move it to node2, it failed. SQL Server service won't start saying : Error…
Nico
  • 302
  • 1
  • 5
  • 17
1
vote
1 answer

Error during Veeam SQL log backup: "Failed to flush file buffers"

My company uses Veeam Backup & Replication to make backups of our VMWare-hosted virtual machines. We use Veeam's SQL log backup feature for our MS SQL 2008 R2 server. Our backup repository resides on a Buffalo TeraStation TS-XLBF NAS. At some point,…
waldrumpus
  • 117
  • 1
  • 9
1
vote
0 answers

Unable to configure SQL Server log shipping, latch error

SQL 2008 R2, SP1 CU8 both servers, next to each other in the rack, ~10 small databases (total under 50GB). I found that log shipping was broken (for a long time), rebooted secondary as a troubleshooting step. Tried to setup the log shipping…
FredS
  • 63
  • 1
  • 1
  • 11
1
vote
1 answer

SQL Server 2008 R2 connection sometimes fails with 'incorrect login'

As part of our testing suite, next to the Unit Tests which mock everything and don't require a database connection, we also have Integration Tests which do require a database. The Integration Tests are required because we are working with a lot of…
Jensen
  • 133
  • 2
  • 9
1 2 3
…
25 26