SQLAuthority News – Happy Diwali and New Year

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”.

SQLAuthority News - Happy Diwali and New Year diwaliphoto1

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)

Previous Post
SQL SERVER – Recently Executed T-SQL Query
Next Post
SQLAuthority News – Whitepaper – Auditing in SQL Server 2008

Related Posts

No results found.

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.


    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 …


Leave a ReplyCancel reply

Exit mobile version