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 » backup   (RSS)
Showing page 2 of 6 (55 total posts)
  • Update to Rules-Driven Maintenance

    Back in August I posted a first version of a rules-driven solution for backups, index and statistics maintenance and integrity checks. The system in general has been working well, and has saved my team a huge amount of time and effort. We are coming to the anniversary of its use in production soon. Today I offer an update that contains a few ...
    Posted to Merrill Aldrich (Weblog) by merrillaldrich on January 16, 2013
  • Quick Tip - Speed a Slow Restore from the Transaction Log

    Here's a quick tip for you:During some restore operations on Microsoft SQL Server, the transaction log redo step might be taking an unusually long time.  Depending somewhat on the version and edition of SQL Server you've installed, you may be able to increase performance by tinkering with the readahead performance for the redo operations. ...
    Posted to Kevin Kline (Weblog) by KKline on November 14, 2012
  • Backup File Naming Convention

    I have been asked this many times before and again just recently so I figured why not blog about it. None of this information outlined here is rocket science or even new but it is an area that I don’t think people put enough thought into before implementing.  Sure everyone choses some format but it often doesn’t go far enough in my opinion ...
    Posted to Andrew Kelly (Weblog) by Andrew Kelly on October 5, 2012
  • Real tortoises keep it slow and steady. How about the backups?

      … Four tortoises were playing in the backyard when they decided they needed hibiscus flower snacks. They pooled their money and sent the smallest tortoise out to fetch the snacks. Two days passed and there was no sign of the tortoise. ''You know, she is taking a lot of time'', said one of the tortoises. A little voice from just out ...
    Posted to Maria Zakourdaev (Weblog) by Maria Zakourdaev on September 10, 2012
  • 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
  • Backup and the evil RETAINDAYS option

    ''So what bad has this option done?'', you probably as yourself. Well, not much, but I find it evil because it confuses people, especially those new to SQL Server. I have many times seen people specifying something like 3, and expect SQL Server to keep the three most recent backups in the backup file and overwrite everything which is older than ...
    Posted to Tibor Karaszi (Weblog) by TiborKaraszi on July 8, 2012
  • Review the New Migration Guide to SQL Server 2012 Always On

    I had the pleasure of meeting Mr. Cephas Lin, of Microsoft, last year at the SQL Saturday in Indianapolis and then later at the PASS Summit in the fall.Cephas has been writing content for SQL Server 2012 Always On. Cephas has recently published his first whitepaper, a migration guide to SQL Server AlwaysOn. Read it and then pass along ...
    Posted to Kevin Kline (Weblog) by KKline on June 25, 2012
  • 'Backup Completed' is NOT an Error Message

    If you're like me, you like for things to be semantically reliable.  Huh?  Said another way, I like for things to mean what they say and say what they mean.  Here are a few examples of I get annoyed by failed sematics - when a footpath is used almost entirely by cyclists, when an escalator is merely stairs, or when a restroom has a ...
    Posted to Kevin Kline (Weblog) by KKline on May 17, 2012
  • Must-Have Resources - SQL Server Backup & Recovery

    One of the things that drives me crazy as I'm getting older is that my brain is losing the capacity to differentiate version numbers. As I speak travel around speaking with customers and at conferences, I find my self saying things like ''I can't recall if this problem was fixed in SQL Server 2000 or 2005. But you don't have to worry about that ...
    Posted to Kevin Kline (Weblog) by KKline on December 8, 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
< Previous 1 2 3 4 5 Next > ... Last »
Powered by Community Server (Commercial Edition), by Telligent Systems
  Privacy Statement