Tag Archive for: sql server

SQL Server Cannot Reinitialize Subscriptions of non-immediate_sync Publications

19 Apr
April 19, 2012

Sometimes when trying to initialize a subscription on a SQL Server database that is involved in a replication topology, you could run into the following error message:

Cannot reinitialize subscriptions of non-immediate_sync publications
Change database context to ‘[db-name]‘.
Error: 20159

A pretty nasty message that means very little.

Read more →

Troubleshooting a Large SQL Server Transaction Log File

07 Aug
August 7, 2011

Managing space on your SQL Server Transaction Log can sometimes be daunting, usually if you have a good backup strategy, and a well moderated database (in terms of monitoring and flagging long running transactions), then you will rarely run into unexpected large growth of your transaction log file. But in the real world this is rarely the case, and there will be occasions when you leave a very long transaction running over night (or days), or there is a schedule clash between two queries, or between a query and the backup schedule, which caused a failure in your log truncation strategy.

The daunting part is making sure that you recover from the situation with minimum data loss and disruption to the database’s recovery strategy. In this post I will go through the most common scenarios of transaction log growth, and how to resolve them.
Read more →