TechNet Magazine: January 2010 SQL Q&A column

Happy New Year! 

The January edition of TechNet Magazine is available on the web now and has the latest installment of my regular SQL Q&A column.

This month's topics are:

  • Using backups for corruption recovery
  • Why snapshot isolation is required when using change tracking, and its performance implications
  • Is DBCC CHECKDB a really comprehensive integrity check?
  • The difference between data file and log file shrinking

Check it out at http://technet.microsoft.com/en-us/magazine/ee914612.aspx.

3 thoughts on “TechNet Magazine: January 2010 SQL Q&A column

  1. Dear Paul,
    Thank you for all the great and practical advice you give us DBA’s. I have a wish to have you explain how to use DPM to backup SQL DB’s. It seems to me that if you can have you DPM setup to do snapshots as often as you would do LOG backups, then you should swith to SIMPLE Recovery Model, does that make sence?

  2. I actually advise against using DPM for most of my customers as it doesn’t go below 15 minute intervals so that’s still potentially a lot of lost data. If you don’t want to lose any data, you’ll still need to do log backups, otherwise switch to SIMPLE. Also, you can’t access the DPM backups if the DPM server is offline. Checkout the product info for more details – I don’t do anything with DPM. Thanks

Leave a Reply

Your email address will not be published. Required fields are marked *

Other articles

Some thoughts on courage

(This is also the Ponderings – editorial – in today’s SQLskills newsletter.) I want to start out this post by sincerely thanking everyone who emailed

Explore

Imagine feeling confident enough to handle whatever your database throws at you.

With training and consulting from SQLskills, you’ll be able to solve big problems, elevate your team’s capacity, and take control of your data career.