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

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

December 16, 2007

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.

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…