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 ...
Some results have been hidden because they may be inaccessible to you
Show inaccessible results
Feedback