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

Password mismatch while logging to sql server

Alright, I have a classic asp application and I have a connection string to try to connect to db. MY connection string looks as follows: Provider=SQLOLEDB;Data Source=MYPC\MSSQLSERVER;Initial Catalog=mydb;database=mydb;User Id=me;Password=123 Now…
user194076
  • 121
  • 4
2
votes
1 answer

SQL Server 2008 R2 - RAM = 128GB, PageFile = 192GB?

Is there a definitive guide for PageFile size on the latest 64-bit servers with large amounts of RAM? I've seen conflicting recommendations, and am wondering if the latest releases have changed the recommendations.
Darian Miller
  • 395
  • 3
  • 10
2
votes
3 answers

Amazon EC2 MS SQL Instances

We have an Amazon EC2 box running the Windows Server 2008 with MS SQL Server 2008 R2. The default instance of the SQL server is running fine (the default MSSQLSERVER), we want to add a second one - when we go to the the set up and configuration (the…
Anonymous
  • 193
  • 1
  • 1
  • 7
2
votes
1 answer

Exceeding the DB size limit on SQL Server Express in READ_ONLY

Possible Duplicate: Can you help me with my software licensing question? If my database is larger than 10GB and I'm using it in READ_ONLY mode, will I be violating the licensing agreement somehow? It appears that SQL Server Express edition only…
Robin
  • 173
  • 1
  • 1
  • 7
2
votes
1 answer

Minimum SQL login permissions for an AD domain group

I've created a web application that uses a SQL Server 2008 R2 database in the background. Application uses integrated security SSPI connection to database so users need granted access to database server. All users that should be using the app are…
Robert Koritnik
  • 912
  • 5
  • 19
  • 35
2
votes
1 answer

Can I log ship from SQL Server 2008 R2 to Sql Server 2008 "R1"?

I have two sql server instances, on is SQL Server 2008 R2, one is the first release of SQL Server 2008 ("R1"), is it possible to log ship from the R2 machine to the R1 machine? If is not possible, is mirroring possible? If that is not possible, is…
Andrew Theken
  • 217
  • 1
  • 3
  • 12
2
votes
1 answer

SSIS 2008 R2 performance and Windows 2008 R2 clustering question

I am testing different configurations for loading data from a remote SQL server using SSIS. In a clustered situation SSIS seems slower to speak to the local clustered SQL instance when compared to a non clustered local SQL instance. It looks like…
Robert_DBA
  • 21
  • 1
2
votes
2 answers

What is maximum memory supported for Microsoft SQL Server Standard Edition (64-bit)

I have Microsoft SQL Server Standard Edition (64-bit) running on Windows Server 2008 R2 Standard (64-bit) with 32GB RAM. It's only database server that runs on this machine. Generally it works fine but I sometimes I get 'could not open a connection…
jlp
  • 141
  • 1
  • 5
2
votes
1 answer

Creating a small .bak file without indexes or excessive log

I recently was asked to ship a .bak file of our database to a client, and through reindexing all tables with a 100% fill factor (to make sure there were no empty slots), and resizing the transaction log, and 'shrinking' the file was still large…
GilesDMiddleton
  • 385
  • 3
  • 9
2
votes
2 answers

Backwards-compatible (to SQL 2000) server version and compatibility version check

I have a script which uses features not present in SQL Server 2000. Specifically, the script creates a stored procedure which uses a data type added in SQL Server 2005. I need to use conditional logic to ensure that (1) the server version is 2005 or…
Gnosian
  • 123
  • 4
2
votes
1 answer

MSSQL 2008R2 Service Broker Initiator Queue Filled With Old Conversations

My initiator queue is filled with about 18 million old messages of either EndDialog or Error message_type_name. Apparently the Microsoft sample code I used to set up internal activation (http://msdn.microsoft.com/en-us/library/cc281517.aspx) didn't…
Aushin
  • 175
  • 6
2
votes
1 answer

Can you upgrade SQL Server 2008 SP2 Standard Edition to 2008 R2 Developer Edition?

We have a development server that was initially setup with SQL Server 2008 SP2 Standard Edition. Is it possible to upgrade that edition to 2008 R2 Developer Edition so we can play with the extra features in Developer Edition?
Mike L
  • 719
  • 1
  • 6
  • 11
2
votes
3 answers

Convert/Upgrade SQL 2005 Standard to 2008R2 Express

I currently have a Server 2003 R2 VM running SQL 2005 Standard. The requirements for Standard have gone away and we can suffice with Express. We also have a requirement to upgrade it to SQL 2008 R2. When trying to upgrade, the SQL installer bombs…
Dan
  • 1,278
  • 18
  • 27
2
votes
2 answers

SQL 2008 R2 on W2K3 Enable AWE (Address Windowing Extensions)

Hi I have a Win 2K3 with 6 gigs of memory. I had 3 gigs, and then added 3 more. However Windows won't recognize more than 4 Gigs as its a 32 bits machine. What do I have to do to make things work? I've two sql instances and set SQL Maximum memory…
Gabriel Guimarães
  • 405
  • 5
  • 18
2
votes
1 answer

SQL Server 2008 R2 error "The program or feature cannot start or run due to incompatibity with 64-bit versions of Windows."

I'm installing SQL Server 2008 R2 using a DVD that says 32/64onto a Windows Server 2008 R2 server. I want to install the 64-bit version of SQL Server 2008 R2. I am installing SQL Server with the failover cluster feature enabled and configured.…
Gabriel Guimarães
  • 405
  • 5
  • 18
1 2 3
…
25 26