Browsing articles in "Issues and Resolutions"
Feb
15
2013

The command failed because the database mirror is busy. Reissue the command later.

Issue: Trying to turn of database mirroring, disconnected mirroring from Principal database but when checked the partner Database, found that database still in restoring mode, when trying to delete it, it failed stating database is part of mirroring as below,     Then ran following command/s which resulted in error, ALTER DATABASE [STASxref] SET PARTNER OFF; ALTER DATABASE [STASxref] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;   Msg 1404, Level 16, State 11, Line 1 The command failed because […]

Feb
11
2013

The log cannot be rebuilt because the database was not clearly shutdown (Microsoft SQL Server, Error: 945)

Today found that soemone has delete log file of one of database and database was inaccessible, when tried to take it offline and then bring online received following error while bringing it online,   “Database cannot be opened due to inaccessible files or insufficient memory or disk space. See the SQL Server errorlog for details”   “The log cannot be rebuilt because the database was not clearly shutdown (Microsoft SQL Server, Error: 945)”     […]

Jan
29
2013

dbc_RemoteWriteFile: ERR – could not write progress status message to the NAME socket

In continuation with my old post where I troubleshoot the Symantec NetBackup Error (31073), today faced similar error on another server where UAC was enabled earlier but disabled later. On investigation found Error (31073) again but this time even after implementing all solutions from my last post link, faced a new error as below, Error: In GUI console, ERR – Error in CreateEx: 0x80070005. CONTINUATION: – Unknown VDI error code In dbclient, 06:24:13.321 [1628.6700] <2> […]

Jan
29
2013

Lock Pages in Memory enabled but “Using locked pages for buffer pool” message not found

On a SQL Server 2005 x64 SP4+CU3 Standard Edition with Lock pages in memory settings enabled, max memory configured, found issue that “Using locked pages for buffer pool” message is not logged in SQL Server Error logs,   How to check Lock Pages in Memory is enabled? Run below commands in SSMS and in result you should see message like “Using locked pages for buffer pool” else configure or troubleshoot based on situation, exec xp_readerrorlog […]

Jan
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] […]

Jan
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 […]

Jan
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 > […]

Jan
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 […]

Dec
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 […]

Dec
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 […]

Pages:«12345»

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 263 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

December 2020
M T W T F S S
« Nov    
 123456
78910111213
14151617181920
21222324252627
28293031  

View Post by Categories

%d bloggers like this: