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

SQL Server 2008 R2 Failover Clusters behaviour on multiple failures

I'm testing the resilience of one of our test systems. We have 2 x DB (SQL 2008 R2 on Server 2008 R2, running in ESXi VMs) arranged in a Failover Cluster. Shutting down the Active SQL Server service doesn't do much - the service is not restarted…
CJM
  • 730
  • 3
  • 12
  • 28
2
votes
1 answer

SCCM 2007 SP2 - Could not connect or execute sql query

I've run into SQL database connection issues while trying to install SCCM 2007 SP2. I have a VM setup that hosts SQL Server 2008 R2 SP2 installed using default settings and setting the services to run using a new domain account named 'SCCMAdmin'.…
Devin Rawlek
  • 71
  • 7
2
votes
2 answers

Moving SQL Server between domains

If a Windows Server machine hosting SQL Server 2008 R2 is changed to another domain, what steps definitely and might need to be done for SQL Server before and after the new domain is joined?
BrianCooksey
  • 83
  • 1
  • 8
2
votes
2 answers

How to improve poor SQL Server performance

We have a virtualized environment using VMware vSphere 5.0 U1 which hosts our Microsoft SQL Server and have very poor performance. the host server is a HP DL360 G5 with xeon X5450's, and the disk space comes from a SAN on HP P4300 G2's using SAS2…
Stuart
  • 123
  • 3
2
votes
1 answer

Connection failed: SQLState: '01000' SQL Server Error: 10061

I'm trying to connect my access front-end to the SQL Server backend. It was working when SQL Server was on my computer but now i'm trying to connect to a server So when I create the DSN file with access I chose SQL-Server driver ( I have also tried…
Marc
  • 123
  • 1
  • 1
  • 4
2
votes
1 answer

Powershell (sqlps) lastbackupdate not changing despite having run a sqlserver backup

I'm using Powershell to check last backup times across all our sqlserver databases. This seems to work really well, but I've got a question If I run this (a cut-down version of the actual script): dir SQLSERVER:\SQL\Server1\default\databases |…
mattypenny
  • 23
  • 3
2
votes
1 answer

Maximum number of articles allowed in SQL 2008 R2 for merge replication

Does anyone know of a Microsoft documented limit for the maximum number of articles in merge replication for SQL Server 2008 R2? I have THIS link that specifies the max for SQL 2012 (i think), which is 256, but I need one for 2008 R2.
DanBig
  • 11,423
  • 1
  • 29
  • 53
2
votes
1 answer

MS SQL Server is accessible locally but not over the internet

When I try to access a named instance of Microsoft SQL server 2008 R2 SP2 on the local network, I have no problem. But when access it outside office from the internet, I can not connect to the database server. It send back the "famous" following…
LudoB
  • 21
  • 2
2
votes
1 answer

Windows 2008 R2 Enterprise SQL Server Enterprise 2008 R2 only using half the memory

We have built a new 2 CPU, 6 core server, with 96GB of RAM. SQL server Enterprise Edition was configured with a maximum memory setting of 92GB. A few days after adding into the load balancer I have noticed that perfmon says that only between 45-46GB…
Chris Wood
  • 133
  • 5
2
votes
1 answer

How do I troubleshoot a server I can't get logged into?

This morning I am unable to log into SQL Server because it appears to be busy doing something, so much so that CPU usage is constantly at 98%-99%. I am guessing that something has gone wrong with the maintenance plan that ran over the weekend, but I…
Karl
  • 133
  • 3
2
votes
2 answers

Transaction log backups

I'm studying for the 70-432 (SQL Server 2008) exam, and I'm a bit confused about how the transaction log works. From what I understand, (correct me if I'm wrong...) the log is actively stored in memory and copied to a file on the drive as often as…
Mirrana
  • 197
  • 2
  • 10
2
votes
4 answers

Do I really need a 128GB pagefile

I'm running out of space on one of my servers and the only space that I can free in the immediate is re-sizing the enormous pagefile. The server has 128GB of memory and is currnetly set to "automatically manage" the pagefile, with a recommended size…
Nick Nau
  • 23
  • 1
  • 3
2
votes
2 answers

what is a good frequency for setting up snapshot replication in sql server 2008

My requirements: I have a publisher database from which I intend to replicate to a subscriber. Not all tables need to be replicated. Amount of data could be ~20-30GB. Given the above: is snapshot replication a good choice? if yes, what is the…
Rithish
  • 23
  • 3
2
votes
2 answers

SQL Server 2008 R2 Cluster with HOSTS file entries to active node on the application servers

I questioned the decision of a colleague concerning the use of a HOSTS file entry on an application server (standard SQL database backed .NET solution), which I think would cause connections to the SQL Cluster to connect only a single node in the…
codewise
  • 165
  • 1
  • 9
2
votes
1 answer

Do I need Windows CALs for a dedicated SQL Server database server?

Possible Duplicate: Can you help me with my software licensing issue? This would seem an easy enough question, but I wasn't able to find any definite answer anywhere. If I'm running SQL Server 2008 R2 on Windows Server 2008 R2, I need proper…
Massimo
  • 70,200
  • 57
  • 200
  • 323
1 2 3
…
25 26