dbTalk Databases Forums  

Can I delete *.tmp files from Microsoft SQL Server\MSSQL.2\OLAP folder?

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


Discuss Can I delete *.tmp files from Microsoft SQL Server\MSSQL.2\OLAP folder? in the microsoft.public.sqlserver.olap forum.



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

Default Can I delete *.tmp files from Microsoft SQL Server\MSSQL.2\OLAP folder? - 12-04-2006 , 07:59 AM






I have a lot of *.tmp files in Microsoft SQL Server\MSSQL.2\OLAP folder.
They are there even after restarting machine. Owner of files is unspecified.

Can I delete these files safetly?

Thanks



Reply With Quote
  #2  
Old   
Peter Yang [MSFT]
 
Posts: n/a

Default RE: Can I delete *.tmp files from Microsoft SQL Server\MSSQL.2\OLAP folder? - 12-04-2006 , 08:29 PM






Hello Vimas,

Nice to meet you again here. I know you's like to remove *.tmp files under
Microsoft SQL Server\MSSQL.2\OLAP folder.

I think it depends, you can check timestamp of those files to see if need
them. I suggest that you move them to other location for couple of days,
delete them if don't get any error afterwards. Usually tmp files shall be
removed automatically after AS service stops, it shall be safe to remove
the files but just keeping them in a different folder in case any other
issues.

If there once service crash or permission issues when deleting the tmp
files, the files may exist under the folder.

Please let's know if you encounter issues after you moving the files to a
different folder or deleting the files. Thank you.

Best Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Community Support
==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscripti...ult.aspx#notif
ications
<http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx>.
Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
<http://msdn.microsoft.com/subscriptions/support/default.aspx>.
==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.


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.