Help! My SQL Server Log File is too big!!! Your email has been sent Overgrown transactional log files can turn into real problems if they are not handled properly. Today SQL Server consultant Tim ...
I have a database on SQL Server 2000 which is about 6GB but the LDF file is 100GB. I have been doing some research on the matter and found out that I have several options. Switch to Simple mode, or ...
New DBA’s to SQL Server assume that the Full Database backup truncates the transaction log – it doesn’t. It does take a snapshot of the transaction log at the very end, so that transactions committed ...