Source: SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave
Share and Publish your Article here Instantly, and Grow your Article Audience. This service is totally free. So Start Sharing Now.
Saturday, September 21, 2013
SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave
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(, 1) BACKUP LOG WITH TRUNCATE_ONLY DBCC SHRINKFILE(, 1) GO [Update:… Continue Reading...
Source: SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave
Source: SQL SERVER – Shrinking Truncate Log File – Log Full | Journey to SQL Authority with Pinal Dave
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment