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

How to add a group to the sysadmin fixed server role in SQL Server 2008 R2?

How can i add a group to the sysadmin fixed server role in SQL Server 2008 R2? See my related question for details step-by-step screenshots detailing showing that you're not allowed to add groups to the sysadmin role. Background information Before…
Ian Boyd
  • 5,373
4
votes
5 answers

Sql Server 2008 - Cannot connect to local default instance

I recently rebuilt my machine to Windows 7 x64, installed Sql Server 2008 enterprise. I can connect fine to other remote instances via Management Studio (be they 2000, 2005 or 2008), but i cannot find my local default instance. I have verified…
Tone
  • 621
  • 4
  • 13
  • 29
3
votes
1 answer

Tables in the SQL Server "master" database, will they cause problems?

Folks, please be kind on me... I'm just an 'accidental' DBA due to our DBA resigned, so I'm totally a newbie in DBA... You see, I have this application, "ESET Remote Administration Server" (ERAS) that stores its logs and analysis on (originally) a…
pepoluan
  • 5,138
3
votes
2 answers

Attempting Unauthorized operation - SQL 2008 R2 install

I've been banging against this for a few days. Keep getting this unauthorized error when trying to install SQL 2008 R2 on a Windows 7 machine. I've changed permissions on the key, does not fix... Created an admin user, gave specific permissions…
Fred L
  • 31
2
votes
2 answers

How do I force a restore over an existing database?

I have a database, and i want to force a restore over top of it. I check the option: Overwrite the existing database (WITH REPLACE) But, as expected, SSMS is unable to overwrite the existing database. Of course i don't want different filenames; i…
Ian Boyd
  • 5,373
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,453
  • 1
  • 30
  • 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
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
2
votes
2 answers

SQL Browser service doesn't work when Login account is anything but LocalSystem

I have a named instance of SQL Server 2008 R2. When I attempt to connect to the named instance I get the following error (if the browser service is set to logon as anything other than Local System): A network-related or instance-specific error…
Chloraphil
  • 251
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
vote
1 answer

SQL Server Agent is not visible in SSMS

I have been monitoring the server for past 4 days but i am not able to see agent on SSms but the agent service is in running mode and the server is of standard edition
Suchita
  • 11
1
vote
0 answers

SQL Server 2008 R2 log shows backups (I/O suspend, resume) several times an hour

I am troubleshooting a server issue that may or may not be related... On my SQL Server 2008 R2 instance running on Windows Sever 2008 R2 (VMWare), the logs show: Each database is backed up every 6 to 9 minutes with the following sequence of log…
jlnorsworthy
  • 121
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
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
1
2 3