April 19, 2010 at 1:55 am
Hi friends,
couple of SSIS jobs executing at 00:00 get the following error ,indicating no free space in drive F.
but F has 8GB free space and datafiles in this drive aren't auto growing. These jobs are scheduled daily but they fail few times in a week.
what could be the possible reason.SSIS package transfers data from SQL2008 instance to SQL2000 instance on another host.
Message
Executed as user: KOSDOMANIN\servicekossql. Write to sparse file 'F:\Program Files\Microsoft SQL Server\Data\BireyselATM_1.mdf:MSSQL_DBCC9' failed due to lack of disk space. [SQLSTATE 42000] (Error 5128) Write to sparse file 'F:\Program Files\Microsoft SQL Server\Data\BireyselATM_1.mdf:MSSQL_DBCC9' failed due to lack of disk space. [SQLSTATE 42000] (Error 5128). The step failed.
Regards,
MShenel
April 19, 2010 at 2:21 am
is your AV locking the file or there is some vm stuff taking a snapshot of the disk and freezing the i/o for some time.
April 19, 2010 at 2:34 am
hi,
we have Symantec AV and excluded mdf,ldf,trn files so i guess this not related to AV.
about snapshot I am not sure i'll check it out.
Thanks.
Regards,
MShenel
April 19, 2010 at 3:18 am
Hi again,
there is no snapshot stuff neither on DB level nor storage.
we have datafiles on other drives as well. but the error is always about F.
still looking for an answer.
Regards,
MShenel
April 19, 2010 at 5:06 am
have you tried running the ssis from the a/c sql is running.
April 19, 2010 at 5:11 am
how am i going to do that?
Regards,
MShenel
April 20, 2010 at 6:58 am
any workaround?
Regards,
MShenel
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply