dbTalk Databases Forums  

Recovering disk space after crash during processing

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap


Discuss Recovering disk space after crash during processing in the microsoft.public.sqlserver.olap forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Barb Gengler
 
Posts: n/a

Default Recovering disk space after crash during processing - 01-20-2006 , 06:00 PM






After letting a cube process run 36 hours, I received message about low disk
space. I ended up using Task Manager to stop the process.

First, yes I do have an issue with such a long process (have had the
partition process in < 6 hours in the past) and was trying various
suggestions posted to get the cube built. Next I am going to try recreating
cube from scratch.

But first, I need my 9GB back! Some temp file(s) somewhere must be eating
up space that didn't clear when I crashed the process. But I can't for the
life of me find it/them. Can anyone help me find my space?

AS2k, developer's edition

Thanks

Reply With Quote
  #2  
Old   
 
Posts: n/a

Default Re: Recovering disk space after crash during processing - 01-23-2006 , 05:53 AM






Right click on your server in Analysis Manager and check the properties.
In the general tab there will be a property for the temporary file
folder. This is where your temp files will be sitting. I think by
default this is the same as data directory.

If you are going to reprocess the database from scratch anyway, you
could stop the Analysis Services service and delete the entire database
folder from the data folder and then restart the service.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <D1637D0B-5312-46ED-9ED8-CC25775C09A7 (AT) microsoft (DOT) com>, =?Utf-
8?B?QmFyYiBHZW5nbGVy?= <Barb Gengler (AT) discussions (DOT) microsoft.com> says...
Quote:
After letting a cube process run 36 hours, I received message about low disk
space. I ended up using Task Manager to stop the process.

First, yes I do have an issue with such a long process (have had the
partition process in < 6 hours in the past) and was trying various
suggestions posted to get the cube built. Next I am going to try recreating
cube from scratch.

But first, I need my 9GB back! Some temp file(s) somewhere must be eating
up space that didn't clear when I crashed the process. But I can't for the
life of me find it/them. Can anyone help me find my space?

AS2k, developer's edition

Thanks


Reply With Quote
  #3  
Old   
Barb Gengler
 
Posts: n/a

Default Re: Recovering disk space after crash during processing - 01-23-2006 , 07:57 AM



Thanks, issue was that the two .tmp files were displaying in Windows as 0
bytes so I wasn't "finding" them -- I was looking for big file! I
inadvertently discovered the file when looking at a defrag report.
Thanks.
Barb

"Darren Gosbell" wrote:

Quote:
Right click on your server in Analysis Manager and check the properties.
In the general tab there will be a property for the temporary file
folder. This is where your temp files will be sitting. I think by
default this is the same as data directory.

If you are going to reprocess the database from scratch anyway, you
could stop the Analysis Services service and delete the entire database
folder from the data folder and then restart the service.

--
Regards
Darren Gosbell [MCSD]
Blog: http://www.geekswithblogs.net/darrengosbell

In article <D1637D0B-5312-46ED-9ED8-CC25775C09A7 (AT) microsoft (DOT) com>, =?Utf-
8?B?QmFyYiBHZW5nbGVy?= <Barb Gengler (AT) discussions (DOT) microsoft.com> says...
After letting a cube process run 36 hours, I received message about low disk
space. I ended up using Task Manager to stop the process.

First, yes I do have an issue with such a long process (have had the
partition process in < 6 hours in the past) and was trying various
suggestions posted to get the cube built. Next I am going to try recreating
cube from scratch.

But first, I need my 9GB back! Some temp file(s) somewhere must be eating
up space that didn't clear when I crashed the process. But I can't for the
life of me find it/them. Can anyone help me find my space?

AS2k, developer's edition

Thanks



Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.