Do log records ever move in the transaction log?Commented on: 2 years ago
(May 29, 2012)
To find out what is preventing your log from shrinking, run this command.
DECLARE @DatabaseName VARCHAR(50) ;
SET @DatabaseName = 'NAMEOFDATABASE' --Add name of database
SELECT name ,...
For some businesses, conducting a health check can be cumbersome, time-consuming, and the results, well, frustrating. However, a health check can be easy and rewarding for any business that wants to improve server performance, especially if you take the time to find the right solution provider....More