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

Data file size - SQL Server 2008

I am transferring a database that i made onto a server machine, but the size of the database is around 8GB, for some reason. It shouldn't be needing so much space as i only have a few hundred records. How can i reduce this size? And if anyone knows,…
user1319424
2
votes
1 answer

How to set up SQL Server to offer high availability during windows updates

We have a load-balanced web farm talking to a single SQL server instance. It is easy to demote web servers, install Windows updates, reboot, and then bring them back into the fold. However, we have to schedule downtime to service the SQL Server…
Michael Teper
  • 484
  • 3
  • 13
2
votes
0 answers

SQL Server 2008 R2 mirroring failing

I have two Windows 2008 R2 (Amazon EC2) instances running SQL Server 2008 R2. I use 9TB striped disks (9x1TB EBS volumes) for storage. One server is running as principal and second one as mirror. Both started from the same image, database and tlog…
andriusn
  • 21
  • 1
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
  • 3
  • 5
  • 15
2
votes
3 answers

SQL Server stops regularly on every windows restart

Edit 3 & 4 Added Although the SQL Server instance is set to run automatically and TCP also is enabled in its Network Configuration, the SQL Server is stopped after each system restart. I have to go into the configuration and start it again…
Kasrak
  • 123
  • 1
  • 7
2
votes
1 answer

SQL Server Reporting Services subscription creation silently fails. No error message is displayed, but the subscription does not get created

I'm trying to set up a subscription for a SSRS report. I have deployed the report to the server and I can view the report in a web browser with no problems. I have tried to reproduce this issue on other servers and I cannot get it to fail in the…
jwnace
  • 163
  • 1
  • 4
2
votes
1 answer

How can I assign more than 2GB memory to my SQL Server 2008 R2 Web Instance?

I have a Windows 2008R2 Web server running SQL 2008R2 Web 64-bit. The server has 8GB of memory installed. See this from SSMS: In the SSMS management interface, I am unable to configure the server to use more than 2GB of memory. I've considered just…
Andrew Barber
  • 1,089
  • 12
  • 23
2
votes
1 answer

How to Configure SQL Server 2008 R2 Log Shipping

I need to set up a standby server using SQL Server Log Shipping. This is my first time doing this, so I'm following the instructions in the SQL Help step by step. Of course, I ran into a problem at the first step. The help file says: Right click…
Tim Long
  • 1,738
  • 1
  • 21
  • 41
2
votes
2 answers

Timeout in connection to a SQL Server instance in LAN

From one windows 7 machine I cannot connect anymore to any sql server instance that is in LAN and in same domain of this particular machine. I cannot connect from Management Studio, but also from any client server application. I use sql serer…
user193655
  • 253
  • 1
  • 5
  • 18
2
votes
1 answer

SCCM 2007: I've moved my site database, how do I now delete the old site system?

I have a small SCCM 2007 installation. It has two 'site systems', the primary site system (SCCM01) and the database server (OLDSQL). For maintenance reasons, I had to migrate the database onto a new server (NEWSQL), running the same version of…
growse
  • 8,020
  • 13
  • 74
  • 115
2
votes
3 answers

Filegroup cannot be removed because it is not empty error with no files

When I try to remove 'MYFILEGROUP', I get the error that the filegroup cannot be removed because it is not empty. I already removed all tables, indexes and deleted all files associated with the group. To verify I ran the scripts below:…
Mindy
  • 117
  • 2
  • 2
  • 8
2
votes
4 answers

What happened to IIS lockdown?

A long time ago before I left the Windows environment, there was such a thing as "IIS lockdown tool" - something that Microsoft provided for free. It was meant to well lock down your IIS instance and do some common security tests and tell you about…
user893730
  • 624
  • 2
  • 12
  • 20
2
votes
3 answers

How can I make my SSIS process consume more resources and run faster?

I have a daily ETL process in SSIS that builds my warehouse so we can provide day-over-day reports. I have two servers - one for SSIS and the other for the SQL Server Database. The SSIS server (SSIS-Server01) is an 8CPU, 32GB RAM box. The SQL…
Raj More
  • 327
  • 1
  • 3
  • 11
2
votes
1 answer

How to uninstall SQL 2008R2 Reporting Services via the command line?

I am running SSRS 2008R2 x64 on a Windows Server Core 2008 R2 instance. I need to fully uninstall the SSRS instance leaving the DB's in tact. I know this is normally done through the Programs and Features control panel applet, however this does not…
Brett A.
  • 156
  • 9
2
votes
3 answers

Scaling Out SQL Server 2008 R2

I am looking into the possibilities of how to scale out the sql server 2008R2. simply scaling up wont be enough. "p2p replication" and "distributed partitioned views" look interesting, but both require (multiple?!) enterprise licences which are very…
Flo
  • 21
  • 1
1 2 3
…
25 26