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

learn more… | top users | synonyms

0
votes
0answers
14 views

SQL Server Mirror issue on Mirror side

Team, I am having an issue on one of my Mirroring environment. It is SQL2008R2. DB mirror was somehow broken between principle and Mirror side. Someone(Not sure who is he/she due to offshore support) ...
1
vote
0answers
21 views

Issues identifying SPNs

Background We are performing a server move. In the process, new servers and service accounts have been created. I'm getting two issues which I think are related to SPN's: I've created some SQL ...
0
votes
1answer
14 views

SQL Server, local instance, No process is on the other end of the pipe

On a fresh installation, on my local SQL server instance, using SQL Server Management Studio, I can login with my Windows authentication, but not with my sa user. In both cases, I'm using (local) as ...
0
votes
1answer
48 views

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

MS sql server 2008 R2 database is in suspect mode

I have an darabase on MS sql server 2008 R2, which is currently showing principle, Disconnected / suspect. I have tried, to set DB in emergency mode but got failed and showing message database is in ...
3
votes
0answers
59 views

Exit code 0x84C40013 in silient installation of SQL 2008 service pack 3 installation

Following Command is utilized for installing SQL SP3 pack in Windows server 2008 R2. start /WAIT C:\Temp\SQLSP3.exe /quiet /IAcceptSQLServerLicenseTerms /Action=Patch /AllInstances This complete ...
0
votes
1answer
19 views

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

ASP.NET MVC Getting Error 504 after 10 minutes of File Upload

I have an ASP.NET MVC2 Web application, working with SQL Server 2008 R2, running with IIS 6.2. I have a functionality where one particular admin needs to upload about 5000 documents, which then get to ...
0
votes
1answer
91 views

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

After move SQL isn't releasing memory for queries

We recently made a move from one VM hosting environment to another. The machine we moved is a clone so all settings are identical pre- and post-move. However in our new environment our SQL server is ...
0
votes
2answers
31 views

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

schema specific object access in sql server is not happening after restoring backup

I have an application which is accessing sql objects(stored procs/tables) etc which are defined under a schema 'A' for example A.my_stored_proc. This application is working fine as intended when I ...
-2
votes
1answer
24 views

Seting local MSSQL Server as Database Server [closed]

I have my web site hosted at EC2 server. If I want to give user an option to use their local MSSQL server, so how can I configure that. First of All, Is it Possible? Do I need Static IP? How to ...
1
vote
0answers
41 views

Server 2008 R2 permissions not working

First of all: i posted this yesterday but put in the wrong email so I can't access it again. I am configuring a 2008 R2 server for learning experience. The problem I'm having is the following: ...
1
vote
1answer
33 views

2K8 Cluster - SQL Instance broken on one node

Using a 2-nodes cluster 2008R2 Failover Cluster. A new clustered instance was created (I double checked it's clustered). Instance was installed on node1. When we try to move it to node2, it failed. ...
2
votes
1answer
47 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?
0
votes
0answers
831 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
72 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
27 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
219 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
496 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
167 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
124 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
77 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
526 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
62 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
84 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
129 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
74 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
16 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
490 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
292 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
228 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
1answer
217 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
139 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
4k 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
394 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 ...
1
vote
0answers
185 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 ...
3
votes
4answers
2k 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
1answer
24 views

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 ...
0
votes
0answers
73 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
2k 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
219 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
109 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
2k 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
397 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
355 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
118 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
4k 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 ...