Programming, SQL, Software, SQL Server 2008, SQL Server 2000, SQL Server 2005, Transact-SQL, tSQL, SQL Tips, Database, SQL Server 2012

SQL Server Error: Fixing The Transaction Log for Database is Full Due to log_backup

T-SQL
T-SQL

If you are working with SQL Server, you may see an ominous sounding error: the transaction log for database {Your Database Name} is full due to log_backup Continue reading “SQL Server Error: Fixing The Transaction Log for Database is Full Due to log_backup”

Advertisements
Programming, SQL, Software, SQL Server 2008, SQL Server 2005, Transact-SQL, tSQL, SQL Tips, SQL Server 2012, SharePoint

SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf

SP_Custom_Menu
SP_Custom_Menu

It’s amazing how some SharePoint issues are known problems that don’t get fixed by Microsoft even after many years, and that don’t get mentioned as things one needs to look out for. I found this out recently when I ran up against an error where the entire disk space of my SharePoint SQL Server instance was filled up by a file called SharePoint_Config_Log.ldf . This is ever growing file is apparently a known problem with SharePoint that has existed in many earlier versions and that remains difficult to find a solution for that actually fixes the problem. Continue reading “SharePoint Dealing with the Huge and Growing File Size of SharePoint_Config_Log.ldf”

Programming, SQL, SQL Server 2008, SQL Server 2005, Transact-SQL, tSQL, SQL Tips, System Objects, SQL Server 2012

TSQL Query to List Tables in a Database with Row Counts

Row Counts
Row Counts

In a previous post I talked about how to find highly populated tables in a database. I’m going to expand on that in this post to show how to catalog a database into data-holding tables and supporting details tables. Continue reading “TSQL Query to List Tables in a Database with Row Counts”