I have a Windows 2003 Server running MS SQL 2000. One of the databases log file is 160GB.
Whats the best way to shrink it? And ideally stop it from growing over 50GB.
Its a virtual server, so doesnt have any SQL Backups currently setup.
Can I switch to simple (to reduce the size) then switch it back on (ideally with circular logging at 40GB)?