SQL Log Archives - Page 17 of 17 - SQL Authority with Pinal Dave

SQL SERVER – Find the Size of Database File – Find the Size of Log File

February 8, 2010

I encountered the situation recently where I needed to find the size of the log file. When I tried to find the script by using Search@SQLAuthority.com I was not able to find the script at all. Here is the script, if you remove the WHERE condition you will find the…

SQL SERVER – Solution – Log File Very Large – Log Full

December 16, 2007

Pinal Dave

SQL, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Data Storage, SQL Log

I have been receiving following question again and again either through email or through comments on this blog. My log file is too big, what should I do? Answer to this question is in three steps. Backup the log file to any device. Truncate the log file. Shrink the log…

SQL SERVER – Shrinking Truncate Log File – Log Full – Part 2

November 22, 2007

Pinal Dave

SQL

Shrinking Database, SQL Backup, SQL Log, SQL Restore, SQL Server

About a year ago, I wrote SQL SERVER – Shrinking Truncate Log File – Log Full. I was just going through some of the earlier posts and comments on this blog and one particular comment by Praveen Barath caught my eye. It is a very good explanation. I am copying complete explanation here with full credit to the original author.

SQL SERVER – Shrinking Truncate Log File – Log Full

December 30, 2006

Pinal Dave

SQL, SQL Performance, SQL Server, SQL Tips and Tricks

SQL Backup and Restore, SQL Log, SQL Scripts

UPDATE: Please follow link for SQL SERVER – SHRINKFILE and TRUNCATE Log File in SQL Server 2008. Sometime, it looks impossible to shrink the Truncated Log file. Following code always shrinks the Truncated Log File to minimum size possible. USE DatabaseName GO DBCC SHRINKFILE(<TransactionLogName>, 1) BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY…