I've been working on our Sharepoint Foundation 2010 database, moving databases from one SQL server to another. Since I've moved the logging database (WSS_Logging) it's grown to 2.8GB. It was less than 33MB on its original SQL database server.
How can I clear it down?
Can I set a limit for this logging? Is so how?
I'm already running it in SQL simple Recovery Mode and using SQL shrink wont work as there's not much free space in the Database.