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

C#/asp.net application runs fine on localhost (intranet), but not on server (Internet)

I'm a total n00b when it comes to SQL Server admin stuff, so sorry if this is basic. I've designed a website in C#/asp.net with a SQL Server backend on my local machine. Runs perfectly when I open the site through VS2010 and run it. However, when I…
Johnny Bones
  • 117
  • 1
  • 7
0
votes
1 answer

Can a sql job using a DTS package access data from the wrong column? (turned out to be bad join condition)

We are seeing a Sql job / DTS package fail because it is fed non-numeric character data into an int conversion routine. The data looks like with very high probability that it comes from another column in our tables, where its non-numeric format is…
JosephDoggie
  • 229
  • 2
  • 4
  • 14
0
votes
1 answer

The MSDTC transaction manager was unable to push the transaction to the destination transaction manager due to communication problems

I have a BizTalk server and a SQL server which BizTalk sends messages via WCF-SQL to. The BizTalk server has been calling to this server for over a year with no problems. I came in this morning any suddenly it can't (it was working on Friday). The…
Bensonius
  • 111
  • 1
  • 6
0
votes
2 answers

SQL 2008R2 Failover Cluster without File Share

We are looking to set up a failover cluster for our SQL 2008R2 database. To accomplish this, we have 2 servers, both equipped with Fusion I/O cards that will both have identical copies of our production databases on them. From everything I've read,…
RockiesMagicNumber
  • 123
  • 1
  • 5
0
votes
1 answer

SQL Server 2008 Agent service wont start

We previously had SQL Server 2008 R2 Express to try some things out (I know it is by design that the agent service is disabled in this version) After proving the concept, we upgraded to the standard edition. I did feature add with management tools…
DontStealMyFish
  • 108
  • 1
  • 2
  • 13
0
votes
2 answers

SQL Server 2008 R2 does not utilize allocated memory

Our app runs on a server with 4 core CPU, 8GB RAM and Sql Server 2008 R2 Standard Edition (10.50.1600.1), 64 bit. Server dedicated to Sql Server, no other heavy service is running. We've set min/max memory usage to 4/6.4 GB respectively. AWE is off…
Mehmet AVŞAR
  • 101
  • 3
0
votes
2 answers

Migrate MSSQL 2008R2 to 2012 (new hardware)

Since hardware support for our server ends we are migrating to a new hardware and simultaneously upgrading MSSQL 2008R2 to MSSQL 2012. I searched a little bit and found some guides, but they all assume that I want to use new features of 2012. But we…
KenavR
  • 101
  • 2
0
votes
0 answers

SQLServer Maintenance Plan Cleanup misses files by minutes

I have a set of maintenance plans in place that perform a full backup weekly, and once complete, delete any .bak's that are a week old. This is important, because the DBs are very large and disk space for backups is limited. Usually this works…
Frank Thomas
  • 63
  • 6
0
votes
0 answers

SQL server session tasks all waiting

I have a query that often completes in a fraction of a second (~200ms). Sometimes it takes 10-13 seconds to complete. Doing SET STATISTICS TIME ON it shows: SQL Server Execution Times: CPU time = 231 ms, elapsed time = 13772 ms. This is the only…
Eterm
  • 101
  • 1
  • 4
0
votes
1 answer

How to update system databases in SQL Server

I am having problems updating a system database in SQL Server 2008. Perhaps there is a different way to do it, but I basically need to change/remove growth restrictions on certain log files for a bunch of databases. Being lazy, instead of doing this…
vgru
  • 1,287
  • 2
  • 17
  • 25
0
votes
1 answer

cannot restore database to a different version of MSSQL server

I am trying to restore a database onto a clean install of MS SQL Server 2008 R2. I am using the same installation CD as with the original computer. That PC has since died and I now need to restore the Databases onto this new computer. When I go to…
KriiV
  • 111
  • 1
0
votes
1 answer

TFS Database migration miss the detach step issue

We currently doing the TFS database migration, originally, we suppose to upgrade to 2012 which support SQL 2008 R2, after a period of time, we decide to upgrade to 2013, and unfortunately we are upgrade on the rush and forget forget to detach the…
Jian_H
  • 11
  • 1
0
votes
1 answer

Can't install SQL Management Studio 2008 R2 Express - Throws exception

I am running SQL Server 2008 R2 on a Windows Server 2012 R2 machine. select @@version returns the following string: Microsoft SQL Server 2008 R2 (SP2) - 10.50.4000.0 (Intel X86) Jun 28 2012 08:42:37 Copyright (c) Microsoft…
Matthias Güntert
  • 2,438
  • 12
  • 39
  • 59
0
votes
1 answer

SQL Installation Error In Memory, Can i just add a database to an existing SQL Instance

We have an SBS server running 4 Microsoft SQL 2008R2 instances. I need another for an anti-spam product, but the install fails with an error about possible corrupt memory. I've done some digging and re-installing all the instances isn't an issue so…
Rascal
  • 1
0
votes
0 answers

SQL 2008 R2 says access denied when logging in remotely

I have an SQL 2008 R2 server and a monitoring server both on the same physical network (but different VLANs). The monitoring server is always connecting to the SQL server to run a query and check the output. However, the monitoring server is…
blizz
  • 1,134
  • 1
  • 26
  • 47
1 2 3
…
25 26