How to Archive your SQL Errorlogs into a Table

How to Archive your SQL Errorlogs into a Table Chris Skorlinski Microsoft SQL Server Escalation Services Have you noticed your SQL Server errorlogs taking up a lot of disk space?  Ever wonder what was logged a few weeks ago, but the logs have already rolled over?  Why not create a SQL Agent job and archive…


Enable CDC fails with error Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal

Enable CDC fails with error Msg 22830, Level 16, State 1, Procedure sp_cdc_enable_db_internal Chris Skorlinski SQL Server Escalation Services Problem While enabling Change Data Capture (CDC) on database you get following error: EXECUTE sys.sp_cdc_enable_db Msg 22830, Level 16, State 1, Procedure sys.sp_cdc_enable_db_internal, Line 198 [Batch Start Line 8] Could not update the metadata that indicates…


Lessons Learned in Execution

Note: This article is updated at Project Execution Lessons Learned. I’ve been thinking about execution and the lessons learned.   I’ve summarized some insights and reminders. I’ve been lucky enough to grow up with patterns & practices over the last 10 years, so I’ve been able to see what works, what doesn’t, and the difference that…


Restore of Replicated Database fails with “Cannot drop the table <tablename> because it is being used for replication.”

Restore of Replicated Database fails with “Cannot drop the table <table name> because it is being used for replication.” Sateesh Yele Microsoft SQL Server Support Issue: Restore of a replicated database fails with the following message. Msg 3724, Level 16, State 2, Procedure sp_MSdrop_peertopeer_tables, Line 32 Cannot drop the table ‘dbo.MSpeer_lsns’ because it is being…


Distribution Agent fails with “Could not remove directory” error

Distribution Agent fails with “Could not remove directory” error Sateesh Yele Microsoft SQL Server Support Symptom: The Distribution Clean up job fails with the following error. Executed as user: DomainnameUsername. Could not remove directory ‘C:Program FilesMicrosoft SQL ServerMSSQL10_50.MSSQLSERVERMSSQLReplDataunc’. Check the security context of xp_cmdshell and close other processes that may be accessing the directory. [SQLSTATE…