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
1
vote
0 answers

MSSQL application failing to connect to database server

We run a very old application that connects to an MS SQL server 2008 database using the SQL server native client 10. Sometimes if there has been a power failure with the server the clients will stop communicating with the server. Normally in the…
Matthias
  • 11
  • 1
1
vote
1 answer

Minimal required user permissions for running MS CRM

We have several M$ CRM instances running. Each one has its own dedicated SQL Server instance. The permissions are set up in accordance with the Microsoft recommendations for setting up MS CRM. However, I can't find any documentation regarding…
Reaces
  • 5,597
  • 4
  • 38
  • 46
1
vote
1 answer

Will a SQL incremental backup work for my purposes?

We are transitioning a large amount of data, in the form of a SQL database, from one location to another and the data transfer speeds are very slow but we want to cause as short of an interruption of services to our customers as possible. The idea…
Tony
  • 457
  • 3
  • 11
  • 23
1
vote
0 answers

SQL Database with offline filegroup

I'm using SQL 2008 R2 Enterprise and yesterday I had an hardware-error. During this error one disk went offline, which contains a very unimportant part (filegroup) of the database. Accidentially this part was stored only on one single disk which…
max_payne1256
  • 11
  • 1
1
vote
1 answer

SQL Server Agent is not visible in SSMS

I have been monitoring the server for past 4 days but i am not able to see agent on SSms but the agent service is in running mode and the server is of standard edition
Suchita
  • 11
  • 1
  • 1
  • 2
1
vote
0 answers

Server 2012 slow performance on ESXi 5.5

I'm having performance issues with a virtual Server 2012 that is installed on an ESXi 5.5 (HP-ESXi-5.5.0-iso-5.71.3). The hardware server is an HP ProLiant DL380p Gen8. The server 2012 is acting as an SQL Server (SQL 2008 R2) that is used by…
Jente
  • 161
  • 1
  • 11
1
vote
1 answer

deploy ssis 2012 packages on 2008r2 server

We've developed SSIS packages on ssis 2012, but now upon deployment, we need to deploy these to sql server 2008. I've been searching but haven't found a solution to do this. Is this even possible and what tools do I need to do this?
jelle
  • 35
  • 1
  • 8
1
vote
0 answers

SQL Server 2008 R2 log shows backups (I/O suspend, resume) several times an hour

I am troubleshooting a server issue that may or may not be related... On my SQL Server 2008 R2 instance running on Windows Sever 2008 R2 (VMWare), the logs show: Each database is backed up every 6 to 9 minutes with the following sequence of log…
jlnorsworthy
  • 121
  • 6
1
vote
2 answers

SQL Server 2008 constantly reads MDF file, performance terrible

We have an app that runs SQL Server 2008 R2 Express on the back end on a Windows 2008 R2 virtual server running on VMWare ESXi. Users complain that the app is very slow. I see very high disk IO that does not make sense to me. Background: Average…
user1594322
  • 229
  • 1
  • 4
  • 10
1
vote
1 answer

Unable to run query in SQL Management Studio because of JIT debugging error

Recently I have built a Windows server 2008 and installed SQL Server 2008 and Dynamics CRM 2011 on it. Everything is working fine but when I open the SQL Server management Studio and try to open a new query window, it throws the following error.…
Scorpion
  • 149
  • 2
  • 11
1
vote
1 answer

Is there DDL viewer role in SQL Server?

I have a user that have db_datareader role in SQL Server 2008 I need this user to be able to see Stored Procedures, functions, table scripts, etc. What role is that? I don't want user to RUN DDL scripts (alter tables or procedures). I just want user…
katit
  • 213
  • 4
  • 9
1
vote
4 answers

Separate SQL Server Instance or just new database?

I'm going to deploy an app whose requirement is just 'db_owner' for a database. The database itself must be created separately by the DBA. Based on how the application will work (and its simple requirement), it should be possible to just create a…
pepoluan
  • 5,038
  • 4
  • 47
  • 72
1
vote
1 answer

Installing SQL Server 2012 on older instance

I have SQL Server 2008R2 installed on my server which I can connect either by providing server name "xyz" or IP address "127.xx.xx.xxx". Does it mean my installation is done with default instance? When I am running below query DECLARE @GetInstances…
Zerotoinfinity
  • 105
  • 6
1
vote
0 answers

Should SQL Server backups be scheduled in SQL Server Agent or as a Scheduled Task?

I have inherited a system where a system where our database is backed up by identical scripts, one set up in SQL Server Agent and one set up as a Scheduled Task. Both are running at the same time, so I'd like to disable one of them. Apart from my…
Rob Church
  • 121
  • 4
1
vote
2 answers

SQL Server Database Access fails when User Granted Acess via Domain Group

On a SQL Server 2008 R2 (running on Win2003), we have an issue with logins via domain groups - login access is granted to the server instance, but cannot access certain databases on the server. The SQL server machine is a member of our AD domain,…
nepdev
  • 391
  • 1
  • 7
  • 21
1 2 3
…
25 26