SBS2011 MSSQLMonitoring Database at maximum limits

Under certain circumstances, the database may become unusable, when this happens you can experience behaviors like the SBS console crashing, or incorrectly reporting the status of machines. When this happens there might be a need to create a new, blank, database to regain functionality. Since all the information collected is dynamic, by creating a new database you would lose only any custom reports you may have created in the SBS Console, report customizations, and all the archived reports. Furthermore, upon recreating the database, it will need some time to contact all clients and report on their status, this time may vary, since clients may be offline, it is recommended to wait 48hrs before trying to validate the data.

Create backups with WBAdmin command

Generally to create a backup that is capable of performing a bare metal recovery to the same or dissimilar hardware requires a paid third party application per machine or expensive licenses for multiple machines in the same organisation or even more expensive licenses for technicians. However this article shows how you can perform a backup based on the WBAdmin command available in the Windows operating system.