Post reply

Poll on backup validation

  • March 7, 2009 at 10:27 am

    #197888

    Folks,

    I'm doing a simple poll on my blog on how often people validate their backups (and I'm testing our whether polls will be useful and interesting to folks who read my blog). If you're interested, check it out at Testing a new survey method: backup validation. So far the most popular answer is that backups are never validated :crazy:

    Cheers

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • March 7, 2009 at 10:46 am

    #955513

    The link is broken, but I've contacted Paul.

  • March 7, 2009 at 10:56 am

    #955517

    The link is fixed - look - I can do databases - not Internet stuff, right? 😛

    Thanks Steve

    Paul Randal
    CEO, SQLskills.com: Check out SQLskills online training!
    Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
    SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
    Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005

  • March 7, 2009 at 12:38 pm

    #955538

    I am looking froward to the blog entry once you close the poll; the results look scary heh.

    [font="Arial"]---

    Mohit K. Gupta, MCITP: Database Administrator (2005), My Blog, Twitter: @SQLCAN[/url].
    Microsoft FTE - SQL Server PFE

    * Some time its the search that counts, not the finding...
    * I didn't think so, but if I was wrong, I was wrong. I'd rather do something, and make a mistake than be frightened and be doing nothing. :smooooth:[/font]

    How to ask for help .. Read Best Practices here[/url].

  • March 8, 2009 at 11:16 am

    #955684

    Paul Randal (3/7/2009)

    I can do databases

    oh you do those too in your spare time Paul! LOL

    we use Redgate and set the redgate extended stored procedure to 'verify', not sure if you want just native or 3rd party backups too.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • March 8, 2009 at 11:33 am

    #955689

    Paul Randal (3/7/2009)

    So far the most popular answer is that backups are never validated :crazy:

    At least they have backups.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply