Post reply

Backups to Compressed Folder

  • March 19, 2009 at 9:54 am

    #198102

    Is there some undocumented max file size for compressed folders on server 2003? We see SQL 2005 backup job fail writing to compressed folder when database is 20GB or so.

  • March 19, 2009 at 10:13 am

    #962864

    There is no such limit for compressed folder. The backup might be failing due to no response from the disk for sometime.

  • March 19, 2009 at 10:18 am

    #962869

    Thanks for the reply. If it helps anyone, here's the error message:

    The process cannot access the file because another process has locked a portion of the file.

    I know what that sounds like, but when we remove the compression on the folder, the backup works.

  • March 19, 2009 at 12:05 pm

    #962988

    Well, shoot. Sorry everyone, should have googled this a little longer before posting. I found confirmation that others have had this problem with large backups in compressed folders:

    http://www.sqlservercentral.com/Forums/Topic157874-24-1.aspx

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply