SQL Server Magazine: feature article on using database repair

The September SQL Server Magazine articles are now available on the web and include my latest feature article on Using Database Repair for Disaster Recovery.

It includes a detailed walk-through of a disaster scenario where all backups include the corruption – showing you how to run repair and then try to recover some of the damaged data from an older backup.

You can get to the article HERE (no login required).

Enjoy!

PS Note that the posting date on the article says 2010 – the online editors at SQLMag will fix it shortly.

SQL Server Magazine: feature article on advanced BACKUP and RESTORE options

The June SQL Server Magazine articles are now available on the web and include my latest feature article on Advanced BACKUP and RESTORE Options.

Rather than covering how BACKUP and RESTORE work or how to perform common backup/restore operations I decided to show you some of the less commonly used options that can be very helpful. The article covers:

  • Verifying backup integrity
  • Tail-of-the-log backups
  • Using BUFFERCOUNT and MAXTRANSFERSIZE to tune backup performance
  • Piecemeal and PARTIAL restores
  • Using marked transactions and STOPATMARK and STOPBEFOREMARK
  • Restarting an interrupted restore operation

You can get to the article HERE (no login required).

Enjoy!

Working with SQL Server Magazine

Great news! Kimberly and I have started doing a bunch of work with SQL Server Magazine (of course we're already pretty heavily involved with their parent company Penton Media, as they run the SQL Connections bi-annual conference that Kimberly and I Co-Chair).

I've become a Contributing Editor of the magazine, and Kimberly has been for ages already. We've got a new monthly Q&A column in the print magazine and a blog on the magazine's website. You can get to the blog at http://www.sqlmag.com/blogs/sql-server-questions-answered.aspx and the first post went live today. This is all part of the major revamp of the SQL Server Magazine website that debuted earlier this month.

I've also signed up to write some feature articles and other content.

Be sure to follow the magazine on Twitter too: @SQLServerMag to get notice of new articles and content (and of course me at @PaulRandal).

Enjoy!