In continuation to my first trip, I made my second business trip that was perfectly planned and executed. The requirement was to scale out a financial database that is fairly large. After a two day research and Proof of concepting, we decided to go with SQL Server 2005 Mirroring feature. While in the way, we overcame a few challenges such as SQL Server 2005 mirroring and permission issues. Later a day, we successfully started implementing Mirroring for one of the databases and continued with the others. A snapshot was created for each of the mirrored databases so as to provide read-only access. Its a great solution for anyone who owns a reporting application that only needs read-only access to OLTP databases. A scheduler application was also developed in C# to take snapshots of the database at specific intervals, in order to keep the snapshots up to date to the principal database.
The entire project was completed in just 6 days. We setup the scheduler and moved into production on last Saturday. The team worked hard throughout the entire week. Kudos!
On my way back to the airport, I had a chance to do a quick shopping on LandMark, bought myself a book and got myself a couple of lovely books gifted from the department head for Systems and Applications. One of them is the International bestseller from Paulo Coelho titled The Alchemist.
Mumbai inspired me so much that I have also planned on a personal trip in the summer. Good day ALL!
Posted by Sheriff, Md. at 10:40 AM. Filed under:
(177) Comments • (0) Trackbacks • Permalink