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 (https://blog.sqlauthority.com)
4 Comments. Leave new
Happy Diwali Dave!
Hello Pinal,
Wish you and your family (especially Shaivi) very happy Diwali (though we had it personally) and prosperous new year ahead. hope this new year brings lots of light in your life, lots of joy, happiness, health and wealth.
Thanks,
Ritesh Shah
Hi,
I am regular visitor of your blog…..But today first time i m leaving a reply I m bit curious about this line
“I helped him rebuild data from log file and with little data loss”
I am also a network admin and i have various way to save the DB if i have backup or taking backup of .ldf & .mdf file.
but please give some light on this topic…
Please……i am waiting for your warm response.
Im curious with the same statement mentioned by Sudhanshu. Rebuild data from log file …