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:
Check it out at http://technet.microsoft.com/en-us/magazine/ee914612.aspx.
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
(The Curious Case of… used to be part of our bi-weekly newsletter but we decided to make it a regular blog post instead so it can sometimes be more
We’ve added the ability to purchase a self-service health check using a credit card – no more waiting for a scoping call and then budget
Hello, my name is Paul, and I’m a high-functioning alcoholic. For the last ten years or so, I’ve been an alcoholic. A maintenance drinker –
(Meeps, one of our seven cats, helping with the selection process…) Since my first round of community mentoring back in 2015, when I mentored 54
[Edit 12/16/2022:the deadline for submissions is now closed.] In 2015 I mentored 54 people for six months. In 2020 I mentored 37 people on-and-off for
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.
3 thoughts on “TechNet Magazine: January 2010 SQL Q&A column”
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?
Thank you very much for your fast reply.
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