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

Migrate SCOM 2007 R2 Databases to SQL 2008 R2 (change server)

UPDATE I have a SCOM 2007 R2 server that uses a sql 2005 server. Machine 1: SCOM (SCOM 2007 R2 - W2K3) Machine 2: SQL2005 (SQL 2005 SP2 - W2K3) SQL Cluster: SQLCLUSTER (SQL 2008 R2 on Cluster - W2K8R2) Reporting Services is on one of the cluster…
Gabriel Guimarães
  • 405
  • 5
  • 18
1
vote
1 answer

SQL Agent History settings not being saved

I'm using Win 2K3 R2 + SP2 with SQL 2K8 R2 installed. I'm trying to set SQL Agent History to keep 1 week of logs. So here's what I do: After I connect, I right click SQL Server Agent and select Properties. After that I select History. Then I…
Gabriel Guimarães
  • 405
  • 5
  • 18
1
vote
2 answers

Monitor SQL Server 2008

I've got a SQL Server 2008 R2 instance running on a webserver and I'd like to monitor the running processes it's got or which locks it maintains. The SQL Server process will gradually (running a week or so) take up about 80-90% of the memory so…
riffnl
  • 138
  • 5
1
vote
2 answers

Is this server core intallation possible: DC + SQL + Sharepoint 2010?

I would like to setup a test staging virtual server. If at all possible I'd like to use just one virtual machine. These are the software requirements: Windows Server 2008 R2 Domain controller Web Server SQL Server 2008 R2 Sharepoint Foundation…
Robert Koritnik
  • 912
  • 5
  • 19
  • 35
1
vote
1 answer

what does R2 stands for in SQL Server 2008 R2?

What does R2 stand for in SQL Server 2008 R2? Is it Revision 2 or Release 2? Is it an another version with additional features?
user57795
1
vote
1 answer

SQL Server 2008 R2 - Cannot create database snapshot

Server: Windows Server 2008 R2 X64 Enterprise SQL: SQL Server 2008 R2 Enterprise X64 I have a default SQL Server instance, the SQL Server service account is running as a domain user. I am trying to create a database snapshot in the directory where…
Chris Diver
  • 121
  • 1
  • 6
1
vote
1 answer

Taking SQL Server database ownership after the original owner has left the company

I have inherited administration responsibility for a SQL 2008 R2 server at work. The previous database administrator has left the company, and can no longer be contacted. At this point I have: Full admin rights to the Windows Server Machine that…
Inverseofverse
  • 113
  • 1
  • 3
1
vote
3 answers

"RESTORE HEADERONLY is terminating abnormally" error when restoring backup

When I try to restore a database backup file, I get the following error: An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo) Additional information: Cannot open backup device…
Scott
  • 137
  • 1
  • 1
  • 9
1
vote
3 answers

Merge Replication with Geometry data type

The Merge Agent failed because the schema of the article at the Publisher does not match the schema of the article at the Subscriber. This can occur when there are pending DDL changes waiting to be applied at the Subscriber. Restart the Merge Agent…
Puneet Jain
1
vote
1 answer

SQL Server 2008 R2 install fails with a type load error

I've got a VMWare virtual machine running Windows Server 2008 R2. I've installed the latest updates and the Windows SDK, and I'm in the process of installing SQL Server 2008 R2. I'm not getting very far with the installation, though. When the…
Rytmis
  • 111
  • 3
1
vote
4 answers

Permission denied when creating database in Sql Server 2008 express

Running the following (generated by Sql Server Management Studio) on Sql Server 2008 Express under Vista: CREATE DATABASE [test] ON PRIMARY ( NAME = N'test', FILENAME = N'c:\Program Files\Microsoft SQL…
Tim Abell
  • 1,361
  • 3
  • 11
  • 21
1
vote
2 answers

SQL Server 2008 R2 on Windows 7 Starter?

I tried installing SQL Server 2008 R2 on my machine running Windows 7 starter but got an error: An error occurred during the installation of assembly …
kevin.milo
1
vote
1 answer

install SQL Server 2008 R2 on Chinese Vista fails: Checks if existing performance counter registry hive is consistent

PerfMonCounterNotCorruptedCheck Checks if existing performance counter registry hive is consistent. Failed The performance counter registry hive is corrupted. To continue, you must repair the performance counter registry hive. For more…
Henry
  • 262
  • 1
  • 2
  • 11
1
vote
1 answer

Hourglass won't go away in SQL Server 2008 R2 Management Studio

... after I add a column to a table. I've just started using 2008 R2 Management Studio, but I have a few years experience with 2005 Management Studio. Also, I am connecting to a 2005 instance of a database on a remote server. right-click on a…
JohnB
  • 497
  • 2
  • 6
  • 12
1
vote
2 answers

Is SQL Server Management Studio capable of managing SQL Server 2000 databases?

I know this is really basic, but I can't find the answer in Google or SF, so I thought I'd better just ask. If I run SQL Server 2008 R2 Management Studio on my PC, can I manage a SQL Server 2000 database server? I know I can do it from SQL Server…
Richard Gadsden
  • 3,686
  • 4
  • 29
  • 58
1 2 3
…
25 26