SQL Server 2008 R2 (major build version 10.50.xxxx). Please also tag with sql-server.

learn more… | top users | synonyms (2)

1
vote
0answers
146 views

SQL Server Transactional Replication Distribution Database not keeping up

We have following setup at the moment: 8 Cluster servers (SQL Server 2012 Standard Edition) talking to 2,000 store servers in the field via Merge Replication. The 8 servers are replicating to a ...
1
vote
0answers
244 views

Permission Error when creating Linked Server from SQL Server to Access DB

I created a linked server from my SQL Server 2008 R2 64 bit Windows Server 2008 machine to an Access 2000 Database that resides on another server. The Linked server was created with no trouble using ...
1
vote
0answers
31 views

SSIS package version GUID does not stay stable between runs

We have a large quantity of SSIS packages created in visual studio 2008. Currently running on hundreds of servers. We are logging the details of each package before it runs. One of the things we are ...
1
vote
0answers
86 views

Prdouction Database went into restoring mode

Yesterday one of my production database went into restoring mode,but fortunately i recovered it using below query USE MASTER EXEC SP_CONFIGURE 'Allow updates',1 RECONFIGURE WITH OVERRIDE GO EXEC ...
1
vote
0answers
35 views

Reasons why plans of sys.dm_exec_cached_plans do not match actual plans?

I re-assess index / query optimization and actually focus on key/bookmark lookpus that could be eliminated. Using a script of Jonathan Kehayas I go through the list of query plans that used those ...
1
vote
0answers
85 views

SQL query using CTE not working after database migration

We have recently migrated an application, and in the process we have migrated from SQL Server 2005 to SQL Server 2008 R2. I have noticed that some SQL queries using CTE do not work anymore since. I ...
1
vote
0answers
276 views

Can't uninstall SQL Server 2008 R2 SP3

I have encountered the error on SQL Server 2008 R2 where Report Builder 3 fails to load with error Microsoft.ReportingServices.ComponentLibrary.Controls.dll, has a different computed hash than ...
1
vote
0answers
34 views

Repeated login issue SQL Server 2008 R2 (SSIS)

I'm trying to figure out an issue I'm currently having with an SQL Server connection - there has been a few issues with timeouts on a SSIS package, where it has failed a login attempt - however as far ...
1
vote
0answers
35 views

Why do Statistic recommendations disappear from DB Tuning Advisor after implementing recommended indexes?

Why is it, when analyzing a query through Database Engine Tuning Advisor, statistic recommendations disappear after some or all of the suggested indexes are implemented? For example, Query X suggests ...
1
vote
0answers
51 views

SQL Server Profiler

I had run a SQL trace on SQL server 2008 r2 and had originally saved it to the table format. This table now resides in the database and I was wondering could I export the contents of the table to a ...
1
vote
0answers
31 views

Should I restore without the log file?

I need to restore a SQL Server database with/without the log file. This is for a reporting system and when I restore the log file it is sometimes 8x larger then the data file. I am restoring this once ...
1
vote
0answers
209 views

How to resolve Error 7311 returned by a job running against a linked server?

I have a job and a linked server. The job was working fine for a while, but recently I started getting this error message and I couldn't find a soloution for this. Executed as user: ... Cannot ...
1
vote
0answers
332 views

Could not redo log record on mirror

One of my database mirrors is in the suspended state today and the error log on the mirror shows the following. Could not redo log record (338934:102862:477), for transaction ID (0:848150408), ...
1
vote
0answers
19 views

Transactional publication and database mirroring considerations

I've recently taken over a project, and with it comes 2 backends. 1st is the production services backend and the 2nd is a reporting service backend. Both of which are 2008r2 instances. The production ...
1
vote
0answers
195 views

Moved tempdb, now File 'tempdev2' does not exist

I moved the tempdb first locating the files: use master select name, physical_name from sys.master_files where database_id = DB_ID('tempdb'); GO then I moved each file: use master go alter ...
1
vote
0answers
87 views

SSIS - The value could not be converted because of a potential loss of data, runs fine in BIDS, not on the server

The value could not be converted because of a potential loss of data I'm getting this error when running an SSIS package from a server job. Normally this is some sort of type error, but I can't see ...
1
vote
0answers
26 views

LinqToSql query is having intermittent problems

We have a simple, single table, LinqToSql query running against a SQL Server 2008 database. Every so often the query locks up and stops performing. Clearing the execution plans for the table is the ...
1
vote
0answers
37 views

Schedule data from instance to instance have I maxed out tableDiff

We have a process which uses tableDiff. From one SQL Server 2008 R2 instance to another identical instance. It has worked very well for a long time! I have a situation where one table now has ...
1
vote
0answers
34 views

Linker Server data import

I have three servers, A, B, and C. Each with a individual database. A and B are linked B and C are linked All queries most be run on server B for security reasons. I have data on server C which I ...
1
vote
0answers
37 views

Quorum disk conundrum

I'm working on a problem for one of my company's clients where they are having a problem with their 2-node active-active cluster and which has been failing over lately but not bringing resources back ...
1
vote
0answers
123 views

Data compression within Internal Tables in SQL server 2008R2

We are doing downgrade from enterprise to standard for couple of servers which are not using any enterprise features: For one of our TFS(Team foundation server) database TFS_resx, when we ran ...
1
vote
0answers
71 views

SQLServerAgent Error: 32

A job that "will Recycle SQL Server Agent Error Logs once every week on Sunday at 12:00:00 AM." has been failing this weekend on SQL Server 2008 R2 SP2 Enterprise. This job executes a system stored ...
1
vote
0answers
235 views

How to speed up for huge tables in SQL select query?

I have the following huge tables. Table_1 with 500000 (0.5m) rows Table_8 with 20000000 (20m) rows Table_13 with 4000000 (4m) rows Table_6 with 500000 (0.5m) rows Table_15 with 200000 (0.2m) rows ...
1
vote
0answers
252 views

SQL Server 2008R2 to SQL Server 2012 Install

I'm trying to upgrade one of my SQL servers from 2008R2 to 2012 and I'm getting an error popup within a couple of seconds from starting the setup The Error is TITLE: SQL Server Setup failure. ...
1
vote
0answers
191 views

SQL 2008 R2 Agent stopping sp_who2 running and can't view database or Agent properties

We're experiencing an unusual issue with SQL 2008 R2 SP2 (10.50.4297) where the SQL Agent had stopped but would not restart (this has been fine for months). After investigating the issue we had to ...
1
vote
0answers
314 views

Database Engine Services status failed

Overall summary: Final result: SQL Server installation failed. To continue, investigate the reason for the failure, correct the problem, uninstall SQL Server, and then rerun SQL ...
1
vote
0answers
22 views

source control for SQL Agent Jobs

Our SQL Agent jobs execute different DTSX packages at various steps. e.g \DEVLserver\DTSX\package1.dtsx I want to keep the agent job script in TFS but when I promote it is there any way to change or ...
1
vote
0answers
58 views

Restricting SQL Server access for Azure

I have SQL Server 2008 R2 running on a dedicated server together with a web site hosted on that same server. We now wish to access the SQL Server databases from an Azure Web API, however for security ...
1
vote
0answers
382 views

SQL Server 2005 Cluster Service pack 4 upgrade failure at remote user account

I built SQL Server 2005 ENT Cluster on Windows Server 2008 R2. I need to upgrade it to SQL Server 2005 SP4. However, I get this error at the Remote User Account screen Enter the remote user ...
1
vote
0answers
49 views

tempdb contention issue and excessive pagewrites/s

Still removing the rust from my SQL Server skills, so please bear with some stupid questions here and there... Customer has a SQL Server 2008 R2 running in an Azure VM with 8 cores and 14GB RAM. ...
1
vote
0answers
88 views

Trying to add a NULLable column to a table with over 90 million rows takes a very long time

I have been trying to add a NULLable column to a table with over 90 million rows. ALTER TABLE <TableName> ADD <FieldName> INT NULL; It is taking a very long time (been running for over ...
1
vote
0answers
319 views

ComputerNamePhysicalNetBIOS and “Current Host Server” shows different machines

I have a SQL Server 2008 R2 instance on a two node (say names X and Y) windows server cluster (Windows Server 2008 R2 Enterprise). Server Manager on both nodes shows 'X' as the 'Current Host Server'...
1
vote
0answers
27 views

SQL Server 2008 R2 - Capture or be notified when an sql handle is ran

I'd like to monitor a particular SQL handle and find out who (process id) is running the SQL. Is there a way to retrieve either a list of proc ids who executed the SQL handle in last N minutes or be ...
1
vote
0answers
77 views

Does XP_API deprecation announcement mean that sp_executesql will not be supported in the future?

I have setup an Extended Events session in SQL 2008 R2 to track the deprecation_final_support and deprecation_announcement events. I noticed some "deprecation_announcement" events in my log with "...
1
vote
0answers
110 views

Removing Orphan Pull merge replication subscriptions

I have a merge replication set where I have removed one of the pulled subscriptions. On the subscriber the subscription shows up after deletion. It will not go away. I tried the methods provided on ...
1
vote
0answers
51 views

Using the partition function in the Where clause

I've been asked to test out performance of a database (a test system) after implementing horizontal partitioning. The database is on SQL Server 2008 r2. I'm inheriting this from someone else and ...
1
vote
0answers
53 views

Renaming databases vs backing up and restoring

I am creating a copy of Database A, restoring as database b, executing a job on database b. Upon successful execution, I would like to delete the database A and rename the database B to what the ...
1
vote
0answers
75 views

Average Waiter Count increasing

I am in a nightmare. We have deployed an application to a UAT environment, which has only 7 users. Since then, we have noticed in the logs, a lot of deadlocks, and processes being victims and things. ...
1
vote
0answers
135 views

Setting up a new db-server with same name and ip. Backup/restore or detach/attach

I'm planning to set up a new Win 2012 server, with SQL server 2014 standard. This server is going to replace our current server, Win 2008R2, with SQL server 2008R2. The name and ip is going to be the ...
1
vote
0answers
541 views

Find queries performing full scans

I have a monitoring system that is telling me that the Full Scans /sec on one of my servers is rather high. I am trying to determine which queries may be causing the issue. Is there a simple/easy ...
1
vote
0answers
99 views

Script Rename of SQL Server Database and Database Files

As part of our development lifecycle, we would like to do regular comparisons of versions of our database between two different versions of source control. I expect that there are many automated ...
1
vote
0answers
314 views

SQL Server transaction replication agent error

We are running transaction replication on SQL Server 2008 R2 SP3. Distribution agents are reporting : "Agent is retrying after an error. 3 retries attempted" every 10 minutes. Tried changing ...
1
vote
0answers
39 views

Replication / Bulk Update between Servers

I'm looking to update several tables between two servers daily to have a replica of the data available. My question is, what is the least resource heavy and most effective method to implement this? ...
1
vote
0answers
279 views

SQL Server 2008 Linked Servers Consistently Dropping Connections

I have set up a Linked Server between 2 SQL Server 2008 R2 databases (both 10.50.1600). The linked server worked normally for several weeks until I received reports that users were not able to hit ...
1
vote
0answers
86 views

SQL Server 2008 R2 SP2 Execution Plan not getting missing index suggestions

I have several SQL Server 2008 R2 SP2 that have server collation Latin1_General_BIN. These instances will not give me the missing index suggestion with performing an execution plan. I have other ...
1
vote
0answers
103 views

Database backup hangs both in SSMS and XMLA

I am using SQL Server Analysis Services 2008 R2 Service Pack 3. My database was recently upgraded from Analysis Services 2005 and since that time I have been unable to do a backup either from SSMS or ...
1
vote
0answers
263 views

File group space problem

I'm having some problems with my database usage space. I have a database with autogrowth off and limited size to 150GB. When users try to import files, large databases or other massive transaction ...
1
vote
0answers
25 views

CHKDB is marked RESTORING

I am seeing this in my Microsoft SQL Server 2008 R2 (SP1) database log: The database 'CHKDB_dbname' is marked RESTORING and is in a state that does not allow recovery to be run. This occurred ...
1
vote
0answers
660 views

Application running slow when querying against SQL Server 2008R2

I'm having an application that is starting to run really slow when inserting and querying data from a SQL Server. The database is on a dedicated virtual box with 10 GB ram, AMD Operon 6134 processor (...
1
vote
0answers
537 views

SQL Server spending a lot of time creating sp_dbmmonitorupdate

I have an SQL Server 2008 R2 Standard with around 80 databases, 18 of which are a synchronous mirror primary. I'm having a lot of complaints about database speed lately, so I've started digging with ...