I wish all of you Happy Diwali and New Year. Dīwali is a significant festival an official holiday in India. While Divali is popularly known as the “festival of lights”, the most significant spiritual meaning is “the awareness of the inner light”.
Database tip of the day : Test your backup strategy. Yesterday night I had received call from old client, who lost his live server. When I asked for his backup system, which I helped him to set up, he informed me that as server did not crashed for entire year that did not have it properly. Well, I helped him rebuild data from log file and with little data loss, he is back in business.
Let us have new years resolution that we will have proper backup routine and the routine is verified frequently by restoring the database.
Reference: Pinal Dave (http://blog.SQLAuthority.com)