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

migrate plus move existing biztalk server database from sql server 2008 R2 to sql server 2012

we are planning to move biztalk database from one place to another as well as upgrade the sql server. the initial database is in sql server 2008 R2 and target is sql server 2012. but the thing is that we have to set up database on another system, i…
sameer
  • 1
  • 3
0
votes
1 answer

Sql server 2008 r2 services won't start

We lost power couple of times and I suspect that the UPS didn't keep the server on. I checked the log and it shows that there were couple unexpected shutdowns. I was try to login to sql server database but It won't let me, so I did some…
Rachid
  • 1
0
votes
1 answer

Can Ping but Cannot Telnet directly to SQL Server 2012 Cluster Nodes

We have a monitoring tool (Solarwinds Orion) that needs to connect to a 2-node failover SQL Server Cluster. For reasons outside of our control -- we cannot monitor the CLUSTER IP directly at this time, so we have fallen back to monitoring each…
tresstylez
  • 378
  • 1
  • 4
  • 17
0
votes
1 answer

Clustered instance - kerberos double hop woes

We've recently migrated our virtualised SQL databases to a bare metal solution in an active/active cluster. Everything is working great except SQL Reports. Ok, so a rundown of our setup here as it relates to SQL and Reports: XXYYSQ01 is our old…
Aaron Mason
  • 703
  • 6
  • 20
0
votes
0 answers

Is there a log showing why a Windows server did not restart SQL Server after a reboot?

Our server was rebooted after a Windows Update scheduled for 1am, but after the restart SQL Server did not start up, so our websites were unable to display. Usually this process happens with no manual intervention. Is there a log somewhere which…
MerlinMags
  • 129
  • 1
  • 6
0
votes
3 answers

Why is my DB read-only when attached to SQL Express, but not with SQL Web?

I have an .mdf/.ldf pair, originally created in 2008 R2 Standard, and well under 10GB, with ACLs: d:\db snapshot\DB_NAME.mdf SERVERNAME\SQLServerMSSQLUser$ACCOUNT$MSSQLSERVER:F OWNER RIGHTS:F BUILTIN\Administrators:F d:\db…
David Rubin
  • 153
  • 1
  • 2
  • 7
0
votes
1 answer

How can I delete this ODBC?

I am unable to delete a specific ODBC of type system DSN. I am able to create and remove other ODBC connections on the same server, but a particular ODBC (name = Default) cannot be removed. If I try to rename it to something other than "Default",…
nairware
  • 309
  • 2
  • 10
  • 17
0
votes
0 answers

Unintended SQL Server 2008 Express instance installed

I installed SQL Server 2008 R2 Expess with an instance name SQLX08, then I installed SQL Server 2012 Expess with an instance name SQLX12. Now in the SQL Server Configuration Manager I see, along with these 2 instances, another instance named…
atiyar
  • 133
  • 2
  • 8
0
votes
1 answer

In-Place Upgrade from Windows Server 2008 R2 to 2012

I realize that this might not be the best place to ask this question but I'm not sure which one of the StackExchange websites this question belongs to except for ServerFault. I currently have a Windows Server 2008 R2 machine which has TFS 2010 and…
PoweredByOrange
  • 131
  • 1
  • 5
0
votes
1 answer

SQL Server Web Edition Installation

I have a hosted VM with about 20 client websites on board. Many use a database which is currently SQL Server 2008 R2 (not an evaluation). Because of upcoming licensing issues, I need to change to the Web Edition of SQL Server with my current host.…
IrishChieftain
  • 201
  • 3
  • 12
0
votes
1 answer

How to setup log and data files on SSD for SQL Server?

I'm setting up my production SQL server. I have two 800GB SSD disks available to me (for Windows and SQL Server). Where should I put databases' data and log files? How many tempdb files should I create and what size should they be? Some…
Dennis Gorelik
  • 331
  • 2
  • 8
0
votes
0 answers

Can't Find SQL Server 2008 R2 SP2 uninstall option

Supposedly, the method to uninstall a service pack to SQL Server 2008 R2 (and other versions after a certain point) is through Control Panel > Programs and Features. I think it's supposed to be listed as "Service Pack 2 for SQL Server 2008 R2" or…
alexk
  • 111
  • 3
0
votes
1 answer

SQL Server 2008R2 Transaction Replication Stop and Restart but continue log backups

In a database that is currently being replicated I want to stop the replication (stop the log reader process) for a period of time though I want to continue to take log backups on that same database. Does the log backup free up the log for reuse or…
user49352
  • 123
  • 2
  • 4
  • 12
0
votes
2 answers

Client connectivity to MSSQL

I'm wondering if there is a policy that can be pushed that defaults a client to always dynamically determine the port for connectivity. I'm dealing with a custom C# application that connects to a remote SQL server. SQL Server Details SQL Server…
RevelingSeven
  • 1
0
votes
2 answers

Error after moving WSUS DB from one server to another

I have a WSUS 3.2 Installed on a Windows Server 2003 R2. SQL Server 2005. I want to move the WSUS DB from this server, to our new SQL Server 2008 R2 on a new Windows Server 2008 R2 Machine. After following 2 guides…
Saariko
  • 1,791
  • 14
  • 45
  • 75
1 2 3
…
25 26