Backing up to a NTFS compressed folder

It seems like a good idea to backup SQL Server 2005 databases to a compressed folder, however if your database is larger than roughly 30 GB, you will get the following error:

BackupMedium::ReportIoError: write failure on backup
device 'G:\Backups\200501220402.BAK'. Operating system
error 33(The process cannot access the file because
another process has locked a portion of the file.).

One way to get around this is to stripe the backup to multiple files, for instance:

BACKUP DATABASE AdventureWorks to
DISK='G:\Backups\200501220402.BAK1',
DISK='G:\Backups\200501220402.BAK2',
DISK='G:\Backups\200501220402.BAK3'
WITH FORMAT, CHECKSUM;

Not ideal, but there are two options:

  1. Buy LiteSpeed Backup which includes compressed backups
  2. Wait for SQL Server 2008, which includes compressed backups

About Clay Lenhart

I am a DBA/Technical Architect for Latitude Group and love technology.
This entry was posted in SQL Server Administration. Bookmark the permalink.

19 Responses to Backing up to a NTFS compressed folder

  1. Jeffrey Aven says:

    Another option not mentioned, look into HyperBac, allows you to perform SQL 2005/2000 backups with integrated compression and no changes to the backup scripts/procedures

  2. admin says:

    Thanks Jeffrey! I hadn’t heard of HyperBac before.

  3. Steve Ware says:

    Nice note. This post saved me some searching time and is the only thing that addressed this issue that a Google search linked me to. Regards.

  4. pradeep says:

    Was this issue “error 33(The process cannot access the file because another process has locked a portion of the file.).” on Windows Server 2003 Servers or Windows Server 2008 R2 Servers

  5. Martieasnn says:

    I don’t care about this, now i’m making around
    $5000 a month. There is tricky method i found on the web.

    If you want to learn it too, just type in google:
    Ruthiezx’s method to earn online

  6. This can be a ideal blog site proper who would like to find out about this subject matter. You realize a great deal it’s pretty much hard to dispute along with you (not i truly wants… HaHa). You certainly fit a whole new spin on a subject matter i’m talking about been written about for decades. Wonderful stuff, simply just fantastic!

  7. Nice place of duty. I study impressive by changed blogs everyday. It would all the time live stimulating to read subject matter substance starting different writers and observe a little small piece something from their blog.

  8. Pippa Gray says:

    Thanks for a very interesting website. Where else could I get that type of info written in such a perfect method? I have a undertaking that I am just now operating on, and I have been on the look out for such info.

  9. If some one desires expert view about blogging and site-building afterward i recommend him/her to pay a visit this weblog, Keep up the good job.

  10. Carl Wilson says:

    Every weekend i used to pay a visit this web page, for the reason that i want enjoyment, as this this website conations actually pleasant funny material too.

  11. While, this sort of pellet boiler will necessitated regular cleaning to keep efficiency.

  12. Phil Taylor says:

    you’ve a fantastic weblog right here! would you prefer to make some invite posts on my weblog?

  13. Sam Short says:

    DUNGEN had players competing against one another to complete a series of quests. You can simply search a few sites on Google or any other search engines. Also the several kinds of towers, all featuring monkey’s throwing darts or boomerangs might have helped.

  14. From the time he started performing at the tender age of 5, he managed to catch the attention of people. Both need to be depressed for over a second and it can be a bit tricky to get the timing right. Depending on your technical skill, you may want to hire that professional I mentioned.

  15. Hola, es posible publicar un articulo citando a este post? Gracias

  16. Boris May says:

    That is a great read personally, Need to admit that you’ll be among the finest blog writers My spouse and i at any time saw. Thanks intended for placing information.

  17. Anna Dyer says:

    That is a great tip particularly to those fresh to the blogosphere. Short but very precise info… Thanks for sharing this one. A must read post!

  18. Evan Ellison says:

    What i don’t understood is actually how you are no longer really a lot more well-preferred than you might be now. You’re so intelligent. You recognize therefore significantly relating to this topic, produced me individually imagine it from a lot of various angles. Its like women and men are not interested except it is one thing to do with Woman gaga! Your own stuffs outstanding. All the time deal with it up!

  19. Sarah White says:

    Excellent read. I just passed this onto a colleague who was doing some research on that. He actually bought me lunch as I found it for him! Therefore let me rephrase: Thank you for lunch!

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>