Solved

Deleting Log Files

Posted on 2009-05-07
9
736 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
  • 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
 

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
Free camera licenses with purchase of My Cloud NAS

Milestone Arcus software is compatible with thousands of industry-leading cameras for added flexibility. Upon installation on your My Cloud NAS, you will receive two (2) camera licenses already enabled in the software. And for a limited time, get additional camera licenses FREE.

 
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

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql Audit table 3 60
Selection from table2 where criteria for table1 10 34
Strange msg in the SSMS pane 13 50
Windows Server and Folder Redirection mishap. 5 19
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…
I've often see, or have been asked, the question about the difference between the Exchange 2010 SP1 version, available as part of Small Business Server (SBS) 2011, and the “normal” Exchange 2010 SP1 Standard. The answer to the question is relativ…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…
Many functions in Excel can make decisions. The most simple of these is the IF function: it returns a value depending on whether a condition you describe is true or false. Once you get the hang of using the IF function, you will find it easier to us…

863 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

Need Help in Real-Time?

Connect with top rated Experts

23 Experts available now in Live!

Get 1:1 Help Now