TeQnovation DMCC optimized a large SQL Database in a mirroring setup to have better control over the data growth. Special backup and archiving procedures have been implemented to keep the production servers hard drives space optimal and the database clean with only last 2 years of data. A special mirroring tool was also developed to provide a small user interface to the maintenance team for faster monitoring and control of the mirroring setup without accessing the SQL Server software back-end. The tool has the availability to see the status, force a manual fail-over and monitors the redundancy of both servers to re-initiate the original location of the mirrored database upon a switch-over event. You can read all about it on the following link on our website: https://teqnovation.com/projects/hamriyah-steel-sql-database-improvement-project/.