Solved

Deleting Log Files

Posted on 2009-05-07
9
744 Views
Last Modified: 2012-06-21
I am running out of space on a Server, and I need to keep it going for several more months.
Then they are upgrading to a new Server. I am deleting and moved as much as I can to the D Drive.
As we need to install updates C: It is dropping! We are at 1Gig. Can I delete all the Log files?
I did a *. and come up with a lot of them.
0
Comment
Question by:jackm1
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
  • 2
  • +2
9 Comments
 
LVL 29

Accepted Solution

by:
QPR earned 125 total points
ID: 24332339
so long as you don't mean the transaction log files (*.trn) then yes.
0
 
LVL 60

Expert Comment

by:chapmandew
ID: 24332591
are you referring to the log backup files?  If so, then you can delete them.  What are some of your larger files (extension)?
0
 
LVL 31

Expert Comment

by:RiteshShah
ID: 24332704
You can't delete your .MDF and .LDF file of your database other than that you can delete if you are running out of space.
0
Back Up Your Microsoft Windows Server®

Back up all your Microsoft Windows Server – on-premises, in remote locations, in private and hybrid clouds. Your entire Windows Server will be backed up in one easy step with patented, block-level disk imaging. We achieve RTOs (recovery time objectives) as low as 15 seconds.

 

Author Comment

by:jackm1
ID: 24332776
As I do a *.log search on C:  I come across log text files like: SQLsetup0001_Server-tools.log,
vxInst.log-serveral Acronis backup logs, Symantec reporting Agent logs-
res.log located in the Windows/ntds folder

0
 
LVL 29

Expert Comment

by:QPR
ID: 24332784
yes can delete them
Try doing a disk cleanup through windows too
0
 
LVL 31

Assisted Solution

by:RiteshShah
RiteshShah earned 125 total points
ID: 24332795
those files are backup or log of database itself. you can delete it.
0
 
LVL 60

Assisted Solution

by:chapmandew
chapmandew earned 125 total points
ID: 24332884
sure...you can remove them....OR...even better, move them to a different server.
0
 
LVL 1

Assisted Solution

by:osa2
osa2 earned 125 total points
ID: 24335191
YOu can also look for mailboxes that are no longer used maybe by users who have left the company. Purge the not connected mailboxes can free up some space too.
0
 

Author Closing Comment

by:jackm1
ID: 31579286
Everyone helped with this thanks.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

by Mark Wills Attending one of Rob Farley's seminars the other day, I heard the phrase "The Accidental DBA" and fell in love with it. It got me thinking about the plight of the newcomer to SQL Server...  So if you are the accidental DBA, or, simp…
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In this video, viewers will be given step by step instructions on adjusting mouse, pointer and cursor visibility in Microsoft Windows 10. The video seeks to educate those who are struggling with the new Windows 10 Graphical User Interface. Change Cu…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

688 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question