15
2013
[sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed
Found SQL Server 2005 SP4 CU3 A/P failover cluster SQL services are stopping and starting several times in interval of 30mins to 1 hour. Following errors are found, Application Log Errors: [sqsrvres] printODBCError: sqlstate = 08S01; native error = 0; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] CheckQueryProcessorAlive: sqlexecdirect failed [sqsrvres] OnlineThread: QP is not online. [sqsrvres] printODBCError: sqlstate = 08S01; native error = 2746; message = [Microsoft][SQL Native Client]Communication link failure [sqsrvres] […]
14
2013
Delete Blank rows from long list in excel
To quickly remove unwanted blank rows from long list in excel, do following, Select column having blank rows Press the F5 key on your keyboard (or select Edit, Goto). Click the Special… button. Click the Blanks option and click OK. This will select all blank cells in the range you had previously selected. Now right click and choose delete or choose Edit, Delete, select the Entire Row option and click OK. Useful references: http://chandoo.org/wp/2010/01/26/delete-blank-rows-excel/ […]
14
2013
How to drop Publisher database in Transactional Replication
Dropping publisher database may be required in various scenarios; please find steps which can help you to drop in case you are facing issues with it. I am including roll back approach as well, it helps sometimes. First step -> Drop Publication and subscription Second Step -> Drop Database First step, Right click Publication > Generate Scripts > Generate Drop replication and objects script > Save script to local drive Right click Publication […]
14
2013
Restore Publisher Database which is part of Transactional Replication
Today I have to restore a publisher database from production backup in QA environment which is part of transactional replication in SQL Server 2005, now there are multiple ways to do it, visit this link for Microsoft recommendation. My approach was, Stop and remove replication, restore database, recreate replication without reinitializing Before beginning ensure that there is no pending distributed items by going to replication monitor > publication > double click the subscription > […]
14
2013
Copy folder along with security parameters (ACL) using Robocopy utility
Robocopy is very useful Microsoft provided utility and it comes preinstalled in SQL Server 2008 onwards and can be installed via rktools.exe toolkit in Windows Server 2003 (link) You can check if Robocopy is installed or not via opening command prompt as, Run>CMD> <type Robocopy /?> If it shows parameter list then Robocopy is installed on your system else download and install (if you are not allowed to install anything on your server, then […]
14
2013
SQL SERVER 2005 Resource Fails to come online on cluster after SQL Resource removed and re-added in cluster group
In my case System admin accidently deleted SQL Server 2005 SQL Service resource from SQL cluster group (when trying to remove a disk from cluster) and re-added again but after re-adding SQL server failed to come up and following error noted in SQL Error log, ———– Error: 26054, Severity: 16, State: 1. Could not find any IP address that this SQL Server instance depends upon. Make sure that the cluster service is running, that the […]
27
2012
MSDB database is growing due to sysmaintplan_logdetail table!
Today found an issue where MSDB database size was 4GB and the table which was utilizing more space is sysmaintplan_logdetail, now to fix it first identified the number of records present in table and the oldest dated, then deleted and truncated the maintenance plan history to clear those records, please find how all this is achieved using troubleshooting steps below, Troubleshooting Steps: 1. First connect SQL Server via SSMS, then go to MSDB database […]
27
2012
Size of Transaction Log Increasing and cannot be truncated or Shrinked, log_reuse_wait_desc = replication
Today while troubleshooting log full issue, came across following scenario where two sql servers are in different domain and both are part of simple transactional replication where log file full was on subscriber, after investigation found that replication is working fine and no transaction are in undistributed state still log file is not shrinking, we tried changing recovery model to simple, etc but still issue didn’t get resolved. Finally we manually executed script to mark […]
27
2012
Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx]
Error: Error: 17836, Severity: 20, State: 1 Length specified in network packet payload did not match number of bytes read; the connection has been closed. Please contact the vendor of the client library [CLIENT: xx.xx.xx.xx] Troubleshooting tips: Perform nslookup of the CLIENT IP Address that is listed in the error message [CLIENT: xx.xx.xx.xx] and find out what computer it is that is connecting. Then you need to check that machine and determine what […]
27
2012
Symantec Veritas Netbackup issue – Error (31073)
While setting up netbackup on one SQL Server 2008 R2, faced few errors on netbackup GUI client as, Error 1: Error in GUI interface, Error (31073) INF – Results of executing <C:\lclbin\tsv\bin\Trans_Trunc.bch>: <0> operations succeeded. <1> operations failed. Troubleshooting Steps: With above error, getting no clue how to find the issue, so did following as per article http://www.symantec.com/connect/forums/mssql-2008-backup-status-2-29 , 1. Check the environment variables and add the path of veritas dbbackex.exe as E:\PROGRA~1\Veritas\NetBackup\bin\ (may […]
Subscribe to this blog via Email
Old Posts
- November 2017 (3)
- October 2017 (4)
- September 2017 (2)
- May 2017 (1)
- April 2017 (1)
- July 2016 (3)
- May 2016 (1)
- April 2016 (1)
- February 2016 (2)
- January 2016 (1)
- October 2015 (1)
- September 2015 (1)
- August 2015 (1)
- July 2015 (2)
- June 2015 (3)
- April 2015 (1)
- March 2015 (1)
- December 2014 (1)
- September 2014 (2)
- April 2014 (1)
- January 2014 (3)
- October 2013 (2)
- September 2013 (2)
- August 2013 (4)
- July 2013 (1)
- June 2013 (2)
- May 2013 (5)
- April 2013 (3)
- March 2013 (1)
- February 2013 (9)
- January 2013 (11)
- December 2012 (14)
- November 2012 (3)
- October 2012 (4)
- July 2012 (2)
- June 2012 (3)
- May 2012 (2)
- April 2012 (8)
- March 2012 (6)
- February 2012 (3)
- January 2012 (1)
- December 2011 (5)
- November 2011 (8)
- October 2011 (5)
- September 2011 (3)
- August 2011 (3)
- July 2011 (3)
- May 2011 (1)
- November 2010 (1)
Tags
Calender
M | T | W | T | F | S | S |
---|---|---|---|---|---|---|
« Nov | ||||||
1 | 2 | 3 | ||||
4 | 5 | 6 | 7 | 8 | 9 | 10 |
11 | 12 | 13 | 14 | 15 | 16 | 17 |
18 | 19 | 20 | 21 | 22 | 23 | 24 |
25 | 26 | 27 | 28 | 29 | 30 | 31 |
View Post by Categories
Recent Articles
- Setting up Always ON Availability Group in Multi Subnet Cluster – Recommendations
- Configuring Replication with Always ON Availability Group
- Login failed for user ‘DOMAIN\COMPUTER$’. Reason: Could not find a login matching the name provided. [CLIENT: ]
- Modern Servicing Model (Service Pack and Cumulative Updates) for SQL Server 2017 and onwards
- Fix: SSMS 2012 opening Debug window when pressing F5