SQL Server 2008R2 is a version of Microsoft's SQL Server, released April 2010.

learn more… | top users | synonyms

2
votes
1answer
17 views

Manage SQL Agent Jobs On Multiple Servers

Is there a way to deploy/modify/remove//manage SQL Agent Jobs across multiple servers within a domain without third-party software?
-1
votes
0answers
19 views

Can't connect to SQL Server, SQL Server Services empty

I had SQL Server 2008 R2 working fine on my laptop. I recently had my laptop reformatted and lost SQL Server. I downloaded it again from Microsoft website. Now when I try connecting to it, it gives ...
0
votes
0answers
73 views

Error during Veeam SQL log backup: “Failed to flush file buffers”

My company uses Veeam Backup & Replication to make backups of our VMWare-hosted virtual machines. We use Veeam's SQL log backup feature for our MS SQL 2008 R2 server. Our backup repository resides ...
1
vote
0answers
20 views

Unable to configure SQL Server log shipping, latch error

SQL 2008 R2, SP1 CU8 both servers, next to each other in the rack, ~10 small databases (total under 50GB). I found that log shipping was broken (for a long time), rebooted secondary as a ...
0
votes
1answer
20 views

Restoring From Another Dev's MDF on Same Database: MDF Cannot be Overwritten

Here is the situation: We have multiple developers. We want to import/export(restore/backup) .bak files whilst working on the same, but local, databases(Each dev has a local instance of DB: A). The ...
0
votes
0answers
50 views

Database mirroring issue - Both database is showing principal disconnected

My mirror database went down for a week and when i started it again. It was stuck in recovery disconnected mode. To fix the problem i misunderstood someone and ran the below command. ALTER DATABASE ...
0
votes
0answers
91 views

Error installing SQL Server 2008 R2 service pack 3 on Exchange 2013 DAG

I have a 4-node Exchange 2013 DAG; all servers use the Windows Server 2012 R2 OS; they are all consolidated servers, running both the Mailbox and CAS roles. On each server, Trend Micro ScanMail for ...
1
vote
1answer
48 views

SQL Server 2008 R2 connection sometimes fails with 'incorrect login'

As part of our testing suite, next to the Unit Tests which mock everything and don't require a database connection, we also have Integration Tests which do require a database. The Integration Tests ...
0
votes
1answer
46 views

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

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 ...
0
votes
2answers
169 views

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 ...
0
votes
2answers
52 views

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 ...
-1
votes
1answer
46 views

Windows update 2919355 causes our SQL based app perf to drop to 1/6 of previous perf

We have a VB6 app calling out to a local SQL2008R2 instance. We have had complaints about it's performance dropping considerably. After a lot of experimental research, we have determined at least 1 ...
1
vote
1answer
76 views

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. ...
1
vote
1answer
62 views

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 ...
0
votes
0answers
12 views

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 ...
0
votes
0answers
246 views

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 = ...
0
votes
1answer
126 views

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

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 ...
0
votes
0answers
84 views

Unexpected Sql Server 2008R2 / Server 2008 reboot (bsod) on increasing maxmemory SQL setting

The server OS is Server 2008 x64 and its role is DB server + SSIS (SQL Server 2208R2 x64). (VMWARE ESXi 5.1.0 on IBM 3850x5) Until yesterday the total system memory was 8GB and the maxmemory setting ...
0
votes
1answer
87 views

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 ...
-4
votes
1answer
75 views

Setup network between 2 computers connected using wifi [closed]

In my office I have a WiFi Router that allows 2 computers to connect to Internet. I have 2 questions - How can I create a network between these 2 computers for file sharing? Can I access SQL server ...
0
votes
1answer
2k views

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 ...
3
votes
1answer
257 views

SQL Server 2008 R2 Temporary Login Issue

We have a mature SQL Server 2008 R2 server, being used from many C# web applications, each with connection pooling. Last night, all web applications lost the ability to login to the database for 6 ...
0
votes
0answers
98 views

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 ...
0
votes
0answers
101 views

SQL server reporting services Get user IP

USER -> Reporting server -> SQL Serve SELECT CONNECTIONPROPERTY('client_net_address') AS client_net_address return of course IP of reporting server In DOMAIN is this command return true IP of user ...
2
votes
3answers
1k views

Ola Hallengren's SQL Backup to Network Location not working

I have set up Ola Hallengren's SQL Server Maintenance Solution on several SQL Express servers (2008 to 2012 R2) in the past few years. I recently have started having issues with the network backup ...
0
votes
0answers
61 views

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

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
0
votes
0answers
152 views

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

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 ...
2
votes
0answers
25 views

SQL Upgrade Adviser for win2k

I'm trying to upgrade a SQL Server 2000 instance to SQL Server 2008 R2. SQL Server 2000 resides on an old win2k box, and the new SQL instance is being run on a Server 2008 R2 platform. I am attempting ...
0
votes
0answers
1k views

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

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

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 ...
0
votes
0answers
102 views

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 ...
2
votes
1answer
3k views

Connection to SQL Server 2008 R2 Database Server is SLOW

The database server is a VM running SQL Server 2008 R2 on top of Windows Server 2012, 24GB RAM allocated and 2TB of disk space. Overall, the database connections are very slow and one thing that ...
0
votes
2answers
8k views

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 ...
1
vote
1answer
2k views

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

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 ...
4
votes
1answer
3k views

Why is MS SQL Server Using NTLM Authentication?

Windows Server 2008 R2. SQL Server 2008 R2 installed. MSSQL Service runs as Local System. Server FQDN is SQL01.domain.com. SQL01 is joined to an Active Directory domain named domain.com. The ...
1
vote
2answers
349 views

SQL Server 2008 constantly reads MDF file, performance terrible [closed]

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

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 ...
0
votes
0answers
23 views

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

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

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 ...
0
votes
3answers
180 views

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 ...
-1
votes
1answer
160 views

Slow WRITE operations SQL Server, corrupt backup file after COPY

I am not a network type but a Programmer. I have been working with our DBA and Network technician about a problem I am experiencing. First, our DBA recently moved the database I support from one ...
-1
votes
1answer
47 views

SQL Server Express 2008 R2 limitations

When considering to use an Express Edition of SQL Server 2008 for a system that officially is only tested with full editions, what do I need to know about the limitations? Memory, connections? What ...
0
votes
1answer
863 views

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 ...