Feeds:
Posts
Comments

Posts Tagged ‘SQL Log File’

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Query, SQL Scripts, SQL Server, SQL System Table, SQL Tips and Tricks, SQLServer, T SQL, Technology, tagged on February 8, 2010 | 24 Comments »

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 result for all the databases. [...]

Read Full Post »

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

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Data Storage, SQL Query, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on December 16, 2007 | 4 Comments »

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 file. I have previously written [...]

Read Full Post »

SQL SERVER – Shrinking Truncate Log File – Log Full

Posted in Pinal Dave, SQL, SQL Authority, SQL Backup and Restore, SQL Performance, SQL Query, SQL Scripts, SQL Server, SQL Tips and Tricks, T SQL, Technology, tagged on December 30, 2006 | 274 Comments »

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 DBCC SHRINKFILE(<TransactionLogName>, 1) GO [Update: [...]

Read Full Post »

Follow

Get every new post delivered to your Inbox.

Join 16,216 other followers