More in Database Backup and Recovery

  • Apr 11, 2012
    blog

    Enable backup compression by default? 1

    The SQL community was really pleased when Microsoft listened to everyone’s feedback and made backup compression available in Standard Edition of SQL Server 2008 R2 (it was only available in Enterprise Edition in SQL Server 2008). I like backup compression not just for the space savings, but for the time savings during backup and restore operations....More
  • Mar 29, 2012
    blog

    SQL Server Database Corruption, Part VIII: The Importance of Backups

    In Part VII of this series on SQL Server Database corruption we touched upon how backups can be used as an additional means of early detection for corruption – by making sure to validate the checksums of all data being backed up....More
  • Mar 16, 2012
    blog

    SQL Server Database Corruption, Part VII: Backups 1

    In previous posts we looked at how to enable regular checks for corruption and how to set up alerts for IO subsystem problems when they occur. But, as covered previously, one of the key means for properly dealing with corruption is to detect it early – so that you have more options for correcting it at your disposal that you would if it’s allowed to go unnoticed for long periods of time. Consequently, in this post we’ll take a peek at how you can use backups as an additional means of detecting corruption....More
  • Mar 7, 2012
    blog

    SQL Server Database Corruption, Part VI: Regular Corruption Checks

    Previously we looked at how to set up alerts for cases where SQL Server encounters issues with the storage subsystem. Setting those up is a key component to staying alerted to when problems happen – but another great mechanism for detecting corruption early is to set up regular checks for corruption....More
  • Feb 24, 2012
    blog

    SQL Server Database Corruption, Part V: Storage Problem Alerts

    Continuing on from our last post where we looked at setting up CHECKSUM verification as one means of helping more readily detect corruption early-on, we’ll now take a look at how to have SQL Server notify you of any instances where it runs into problems with the IO subsystem....More
  • Feb 21, 2012
    blog

    SQL Server Database Corruption, Part IV: CHECKSUM Page Verification

    In order to be able to better deal with corruption, you need to be able to detect it early. To that end, there are actually a number of different ways to enable early detection of corruption when it happens. Let's look at the use of CHECKSUM Page Verification as the first of these methods....More
  • Feb 9, 2012
    blog

    SQL Server Database Corruption, Part III: Preventing Corruption

    In this post we’ll talk about more about corruption—in terms of addressing how you can prevent it....More
  • Jan 30, 2012
    blog

    SQL Server Database Corruption, Part II: Simulating Corruption

    In my last post I provided an overview of what SQL Server database corruption is—and how it’s almost always caused by problems at the IO subsystem (or disk) level. However, while it’s all fine and well to talk about things in such a theoretical sense, in that post I also mentioned that a great way to get a ‘feel’ for how corruption works is to simulate it a bit on your own. Accordingly, in this post I’ll provide a step-by-step walkthrough of what that looks like by simulating some corruption....More
  • broken data disk
    Jan 27, 2012
    blog

    SQL Server Database Corruption, Part I: What Is Corruption?

    When it all comes down to it there are really only two main things that DBAs need to worry about: making data available to the proper people, and making sure it’s inaccessible to the not-so-proper people. All other considerations are really just appendages to these two concerns....More
  • data center in green, blue and pink lights
    Jan 18, 2012
    blog

    How Can I Use Storage Replication For A Data Center Migration? 1

    The answer to the question here will depend greatly on what storage platforms you have available to you. Assuming that you have some sort of storage array which supports replication to a remote data center you have some pretty neat options available to you....More
  • computer keyboard key labeled backup
    Jan 6, 2012
    blog

    Transaction log corruption and backups 2

    Transaction log corruption is interesting because it doesn’t usually cause any problems apart from failed backups. However, that doesn’t mean it should be ignored....More
  • Jan 5, 2012
    blog

    Should the disks that you are backing up be aligned?

    In short, yes. The LUN or disk which hosts the backups is probably the disk which needs the most write performance....More
  • computer keyboard with red backup key
    Jan 2, 2012
    blog

    Off-Box Backups and Luke-Warm Standby Servers, Part III

    Just having copies of your SQL Server backups in secondary/remote locations is not a disaster recovery plan....More
  • standby button
    Dec 23, 2011
    blog

    Off-Box Backups and Luke-Warm Standby Servers – Part II 1

    Following up on my previous post, when it comes to the need to create off-box backups, there are really only two (well, three) main reasons you’d want to do Off-Box Backups: Three Primary Reasons for Off-Box Backups First: Redundancy. As I pointed out in my last post: If you’re only keeping backups and data on the same server or hardware, then you’re DOING IT WRONG....More
  • screenshot of Back Up Database - SSV3
    Dec 13, 2011
    blog

    Off-Box Backups and Luke-Warm Standby Servers – Part I

    SQL Server’s RESTORE statement is insanely powerful. Not only because of the obvious fact that it can be handy in a disaster (when you have regular backups in place), but because it’s also so incredibly versatile....More
  • SQL Server diagram of FULL Backup
    Nov 29, 2011
    blog

    Breaking the Backup Chain – REDUX (Or Eating Crow) 2

    While I like to pride myself on being professional enough to admit when I’m wrong, it turns out that I’m a bit more shallow than I’d like to be. For example, I commonly tell my clients that I don’t know everything about SQL Server (and that anyone who claims to know everything is someone they should run away from). Consequently, I don’t mind being wrong when I ‘guess’ at things with them as we’re figuring out various problems and issues together....More
  • Nov 17, 2011
    blog

    Unused Secret Weapon: COPY_ONLY Backups 8

    COPY_ONLY backups were a great addition to SQL Server 2005 (and up). Without them, it was all to easy for DBAs, devs, and SysAdmins to create a ‘backup’ for dev/testing purposes which would actually, silently, break the Log Chain and put production data in severe risk....More
  • blue backup key on keyboard
    Oct 31, 2011
    blog

    SQL Server Backups: When More is Less 3

    For most reluctant-DBAs there’s a certain degree of mysticism or ‘unknown’ about the SQL Server backups that they get ‘roped’ into managing. Moreover, for the uninitiated, there are a number of things about how SQL Server works that can seem counter-intuitive....More
  • Aug 16, 2011
    blog

    If It's Instant, It Isn't A Backup 1

    Pretty much every storage vender supports the concept of snapshots. Often these storage snapshots are presented to companies by the vendor as a way to take SQL Server backups without having to worry about eating large amounts of space. Some companies will even use this instead of tape backups. Due to the way these snapshots work they do not make reliable backup....More
IT/Dev Connections

Register now to get the best rate available!

From the Blogs
computer keyboard with blue save money key
Apr 15, 2014
blog

Save Thousands in Licensing Costs for SQL Server AlwaysOn Availability Groups

Windows Server 2012 or Windows Server 2012 R2 Standard Edition is a great way to save thousands on licensing—and save yourself some serious headaches when deploying SQL Server AlwaysOn Availabiliity Groups....More
Apr 8, 2014
blog

NoSQL: Eventual Consistency Yields Major Flaws

While I believe that NoSQL can have some places where it legitimately makes sense, I also believe that NoSQL is also the patently wrong choice for a number of different types of applications or use cases....More
Apr 1, 2014
News

SQL Server 2014 Now Available—No Joke

Initial word on the street is that SQL Server 2014 has been very stable so far—which is probably why it went to release so quickly and bypassed what would typically have been another pre-release....More
SQL Server Pro Forums

Get answers to questions, share tips, and engage with the SQL Server community in our Forums.

Sponsored Introduction Continue on to (or wait seconds) ×