Viewing 2 posts - 1 through 2 (of 2 total)
You can Use the following Query to Shrink the Log File.
DBCC SHRINKFILE(<TransactionLogName>, 1)
BACKUP LOG <DatabaseName> WITH TRUNCATE_ONLY
For More Info Please Read : http://blog.sqlauthority.com/2006/12/30/sql-server-shrinking-truncate-log-file-log-full/
May 31, 2010 at 3:10 am
I want to share this across as I recently faced issue. Today in morning when I tried to connect to database server, I find it in suspect mode. At this...
May 31, 2010 at 3:02 am