VMware KB: Troubleshooting transaction logs on a Microsoft SQL database server

VMware KB: Troubleshooting transaction logs on a Microsoft SQL database server: Troubleshooting transaction logs on a Microsoft SQL database server
Prevent logs from filling up the server:

1. Log in to the Microsoft SQL 2005/2008 Server as an administrator.
2. Open up SQL Management Studio.
3. Right-click the database that VirtualCenter is using.
4. Click Properties.
5. Click the Options link.
6. Set the Recovery Model to Simple
7. Click OK.
8. Once this is complete, right click on the database again.
9. Click Tasks>Shrink>Files.
10. On the Shrink Database window select the file type as 'Log' . The file name appears in the filename drop down as databasename_log
11. The space used versus the space allocated displays. After you set the recovery model to Simple, the majority of the space in the transaction log released.
12. Ensure that the Release unused space radio button is selected.
13. Click OK on this window to shrink the transaction log.