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

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)

About these ads

4 thoughts on “SQLAuthority News – Happy Diwali and New Year

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

    Like

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

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s