Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Log File Problem

Status
Not open for further replies.
riya

riya

Programmer
Mar 1, 2001
12
0
0
IN
Hi all,

How to Delete the Log files Accumulated in the server thro' Query Analyzer(I mean TSQL Command)?

Thanx..
 
Sort by date Sort by votes
You can't normally delete the log file; you can shrink it through various means, but you should not delete it. Robert Bradley
teaser.jpg

 
Upvote 0 Downvote
You may also detach database, delete log file ant attach it again. John Fill
 
Upvote 0 Downvote
Which log files are you referrinf to - errorlog, transaction log or backup log? if the database log is too large or not getting deleted properly, after performing a full database backup you can run dump trans XXXXX with truncate.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
119
Mike Lewis
Mike Lewis
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
142
Auguy
Auguy
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
45
bmacbmac
bmacbmac
ahmedsa2018
  • Locked
  • Question
How to export 20 milion rows to only one file ?
Replies
2
Views
71
JeffModen
JeffModen
Colin Burton
  • Locked
  • Question
Determine if a file exists on s different server to the SQL Server 1
Replies
2
Views
184
gmmastros
gmmastros

Part and Inventory Search

Sponsor

Back
Top