THE SQL Server Blog Spot on the Web

Welcome to SQLblog.com - The SQL Server blog spot on the web Sign in | |
in Search

Browse by Tags

All Tags » disaster recovery   (RSS)
Showing page 1 of 2 (12 total posts)
  • Mission Critical Performance Enhancements in SQL Server 2014 on DBTA.com

     Microsoft has three major feature sets that they are advancing with SQL Server 2014 (SQL2014). One is called “Mission Critical Performance.”  Microsoft wants to stake out this ground not only as performance enhancements in the relational engine, but also those features which support better data availability, performance, security, and ...
    Posted to Kevin Kline (Weblog) by KKline on November 28, 2014
  • SSMS 2012 Restore GUI Gotcha

    Today I want to bring to your attention an issue in the SQL Server Management Studio 2012 restore GUI. In many ways the new restore dialog is nicer than the old one, with new features and added convenience – but, as is always the Achilles heel of GUI tools like this, if you don’t know what’s really going on it can bite you. I’m not sure what to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 15, 2013
  • Paul Randal’s Disaster Recovery Step-by-Step Poster

    If you were looking for Paul Randal’s [Blog|Twitter] DR poster and couldn’t find it anywhere on the net, I have good news for you: I saved a copy on my PC before it was taken down, and (with Paul’s permission) wanted to make it available here. So, without further ado, enjoy the poster.
    Posted to Argenis Fernandez (Weblog) by Argenis on February 7, 2013
  • High-Availability White Papers and Resources for SQL Server

    In foreground, attendee makes dreaded ''shoot myself'' hand sign to the speaker.I was just telling the good people of Charlotte about how they (and how YOU) need to read all things by Paul Randal (blog | twitter), except for all of his cheesy romance novels like Caress and Conquer written under the nom de plum of ...
    Posted to Kevin Kline (Weblog) by KKline on July 26, 2012
  • T-SQL Tuesday #19: Blind Spots

    A while ago I wrote a post, Visualize Disaster, prompted by a real incident we had at my office. Fortunately we came through it OK from a business point of view, but I took away an important lesson: it’s very easy, whether your organization and your team is savvy about disaster recovery or not, to have significant blind spots with regard to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on June 14, 2011
  • Scandalous II: Shh! I am De-duplicating Compressed Backups

    This is part II of two Scandalous posts. Watch, mouth agape, as I run with scissors, right up against prevailing wisdom! Unfollow me now, before it’s too late! Here’s the thing. There are two really outstanding posts out there on the ‘tubez that explain in vivid detail the problems with sending compressed data into a de-duplicating appliance. And ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on April 23, 2011
  • Visualize Disaster

    Or, How Mirroring Off-Site Saved my #Bacon My company does most things right. Our management is very supportive, listens and generally funds the technology that makes sense for the best interest of the organization. We have good redundancy, HA and disaster recovery in place that fit our objectives. Still, as they say, bad things can happen to ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on March 8, 2011
  • Pop Quiz: Restore a Database to the Point in Time when a Full Backup Started?

    Recently we've had to interview some SQL Server DBA candidates for our team, and we were looking for the type of open-ended technical questions that would draw out interviewees and let us get a sense of their thought process. A surprisingly simple question came up that seems to work well - it makes the candidate think through and explain ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on November 1, 2010
  • Don't get burned by replication of SQL Server files

    Here's a tidbit for those who might have SQL server in their environments, maybe without knowing all the nitty gritty low-down: if you try to use file system replication (robocopy, xcopy, repli-whatever) to maintain a DR server from your production SQL Server, you might be in for a nasty surprise. I recently had to troubleshoot a scenario ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on February 1, 2010
  • Oh, the horror! Please stop telling people they should shrink their log files!

    I realize that there are some cases where, in an emergency, you need to shrink a log file because it took over the drive.  In SQL Server 2005 and earlier, you could get out of the jam quickly, by issuing a BACKUP LOG WITH TRUNCATE_ONLY (followed by DBCC SHRINKFILE).  In SQL Server 2008, this ''feature'' within BACKUP LOG is no longer ...
    Posted to Aaron Bertrand (Weblog) by AaronBertrand on July 27, 2009
1 2 Next >
Privacy Statement