|
Home > Archive > MS SQL Server > May 2005 > Backup failing in compressed folder
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Backup failing in compressed folder
|
|
|
| BackupMedium::Report
IoError: write failure on backup device
'xx:\mssql\backup\xx
xxxxx.bak'. Operating system error 33(The process cannot
access the file because another process has locked a portion of the file.).
I'm getting the above error when I try and backup to a large SQL database to
a compressed folder. It works fine when not to a compressed folder ( NTFS
compression ). The database fails at 82 percent completion. The data is
roughly 50 gigs in size. This might be a low level NT problem. I'm running on
NT 2000 SP4.
Couldn't find anything in the KB, thought maybe someone here could enter it
as a bug, or maybe knows of work around. I'm going to try to copy the file
into a compress folder to see if it is indeed a low level problem.
thanks
| |
| Mike Epprecht \(SQL MVP\) 2005-05-17, 8:23 pm |
| Hi
Backup up to a Compressed NTFS Folders is not supported as file offsets can
not be calculated correctly.
Regards
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"et" <et@discussions.microsoft.com> wrote in message
news:5EA7C5CE-4EEA-467B-B185- 98087AA2ECC7@microso
ft.com...
> BackupMedium::Report
IoError: write failure on backup device
> 'xx:\mssql\backup\xx
xxxxx.bak'. Operating system error 33(The process
> cannot
> access the file because another process has locked a portion of the
> file.).
>
> I'm getting the above error when I try and backup to a large SQL database
> to
> a compressed folder. It works fine when not to a compressed folder ( NTFS
> compression ). The database fails at 82 percent completion. The data is
> roughly 50 gigs in size. This might be a low level NT problem. I'm running
> on
> NT 2000 SP4.
>
> Couldn't find anything in the KB, thought maybe someone here could enter
> it
> as a bug, or maybe knows of work around. I'm going to try to copy the file
> into a compress folder to see if it is indeed a low level problem.
>
> thanks
>
>
| |
| Mike Epprecht \(SQL MVP\) 2005-05-17, 8:23 pm |
| http://support.microsoft.com/defaul...kb;en-us;231347
--
--------------------------------
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Mike Epprecht (SQL MVP)" <mike@epprecht.net> wrote in message
news:up7v4zzWFHA.612@TK2MSFTNGP12.phx.gbl...
> Hi
>
> Backup up to a Compressed NTFS Folders is not supported as file offsets
> can not be calculated correctly.
>
> Regards
> --------------------------------
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
>
> IM: mike@epprecht.net
>
> MVP Program: http://www.microsoft.com/mvp
>
> Blog: http://www.msmvps.com/epprecht/
>
> "et" <et@discussions.microsoft.com> wrote in message
> news:5EA7C5CE-4EEA-467B-B185- 98087AA2ECC7@microso
ft.com...
>
>
|
|
|
|
|