Currently our transaction log is 50 GB; impressive huh?
I want to switch to simple recovery mode and remove the transaction log entirely.
Do I need to stop any user activity and detach the database. Or can I simply go into management studio and change the recovery mode. How do I then remove the file ?
I switched the live server to simple recovery mode, and then performed a shrink file. Has worked perfectly so far. The file is now 1mb.
(I am aware switching to simple mode will restrict recovery : I won't be able to go to s specific point in time, only to when the last back up was.)