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

Can I restore a SQL Server 2008 R2 backup to SQL Server 2008 R2 Express?

I have a server that's currently running SQL Server 2005 Express, and I need to restore a database backup that a developer has modified using SQL Server 2008 R2 [I think the full version, but still waiting to hear back on whether it's a full edition…
link470
  • 75
  • 3
  • 7
5
votes
2 answers

How quickly will SQL Server release RAM when the OS signals a low memory condition?

From the SQL Server 2008 R2 Books Online: Server Memory Options When SQL Server is using memory dynamically, it queries the system periodically to determine the amount of free physical memory. SQL Server uses the memory notification API…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
5
votes
4 answers

Log Shipping to an Existing Database

We have a few huge databases we would like to log ship on SQL Server 2008. Unfortunately the link between primary and secondary servers is fast enough to handle log shipping but the initial backup/copy would tie up bandwidth for days, if not weeks,…
SeanDav
  • 161
  • 1
  • 3
4
votes
2 answers

Build mirroring on top of SQL2008R2 SQL cluster

On our SharePoint 2010 farm, we are using SQL 2008 R2. Currently, a SQL cluster (with 2 SQL server sitting at same data center) is built to provide auto-failover. However, it has no DR ability. We are requested to provide DR ability to the system.…
Mark
  • 217
  • 3
  • 11
4
votes
1 answer

SQL Server linked server: "Cannot start more transactions on this session."

i am trying to perform an INSERT operation against a linked server: DBCC TRACEON (3604, 7300) BEGIN TRANSACTION INSERT INTO LIVE.Contoso.dbo.Events (EventGUID, EventDate, LoginGUID, UserGUID, EventType, Notes, TargetGUID) VALUES…
Ian Boyd
  • 5,293
  • 14
  • 60
  • 82
4
votes
1 answer

SQL Server Maintenance Plan: Rebuild Indexes and Transaction Log Backup File Size

In my nightly maintenance plan, I was doing everything - reorganising and rebuilding indexes, updating statistics, etc. There's an hourly maintenance plan that does a transaction log backup. I noticed that the transaction log backup immediately…
Ben Curthoys
  • 153
  • 1
  • 6
4
votes
2 answers

How to change max server memory in SQL Server

I was trying to change the max server memory for my database server, and I accidentally saved it as "4" instead of the number I wanted to enter. Now I can't even connect to the server. Is there a way for me to reset the max server memory setting to…
Steven
  • 223
  • 1
  • 3
  • 5
4
votes
3 answers

How do I encrypt SQL Server traffic with IPSEC?

I've found all sorts of documentation on what IPSEC is and how to (in very non-specific ways) configure it, but I can't seem to configure a Windows Firewall With Advanced Security rule that both A) requires all SQL Server traffic to be encrypted,…
Sean
  • 183
  • 2
  • 6
4
votes
2 answers

MS SQL access to restored database without sysadmin role

I have databases from different projects on one server. I can't give all developers administrative (sysadmin) access to the databases. They have to have the permissions needed to create and restore databases. The dbcreator server role works quite…
Hubert Kario
  • 6,361
  • 6
  • 36
  • 65
4
votes
4 answers

Is there a performance advantage to isolating database logs and data on different volumes (same RAID array) across a SAN?

On my old server, I separated them on to different RAID arrays to improve performance. Using a SAN is new to me, so I'm not sure of the optimal configuration. SAN: 48 drives. 10K 600GB SAS. RAID 50. 4 Gbps connection. Updated info: All 48 drives…
Keith Walton
  • 175
  • 1
  • 10
4
votes
1 answer

Difference between "SQL server 2008 standard" and "SQL server 2008 standard for small business"?

There seems to be a big difference in price for these licenses, but after a lot of googling I can't find any info on how the two compare. The blurb for the "small business" version is: "This edition of SQL Server is an entry level edition that is…
Stringent Software
  • 163
  • 1
  • 8
4
votes
2 answers

Installation of SQL Server 2008 R2 hang on Setup-Support files

I'm installing SQL Server 2008 R2 on a customer Windows Server 2003. Setup started ok, installed .NET framework and some Setup files, rebootet. After that I ran setup for a new single-server standalone installation of SQL Server 2008 R2, which…
Sam
  • 909
  • 5
  • 15
  • 28
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
  • 601
  • 4
  • 13
  • 29
3
votes
1 answer

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete installation is happening in Administrative…
Sudheer Muthusamy
  • 61
  • 1
  • 6
3
votes
0 answers

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is filling up memory, not releasing it, and then…
Tony
  • 457
  • 3
  • 11
  • 23
1
2
3
…
25 26