Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sql server logs Expand / Collapse
Author
Message
Posted Wednesday, February 05, 2014 11:07 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 2:58 AM
Points: 14, Visits: 25
Hi every one,


I want to remove or clear log file viewer from sql server logs in sql server 2012 kindly i need help.

Thanks & regards

Rajnidas
Post #1538478
Posted Wednesday, February 05, 2014 11:33 PM
SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Friday, April 18, 2014 6:52 AM
Points: 470, Visits: 823
These files are located in Log with name "ERRORLOG" in the installation drive of your SQL SERVER with the following name "ERRORLOG". By Default there are three files.

you can either simply delete these files from the this folder OR Cut & paste preserve them on a separate location for any further analysis.

one question thou, why you want to clear these files ?

hope it helps
Post #1538482
Posted Thursday, February 06, 2014 12:23 AM


SSC-Forever

SSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-ForeverSSC-Forever

Group: General Forum Members
Last Login: Today @ 7:05 AM
Points: 41,532, Visits: 34,449
By default there are 6 files. You won't be able to delete the active log and to be honest you shouldn't be messing directly with files that SQL works with.

Why do you want to delete them? To cover up something that is logged in the error log that you don't want others to see? Or is the current log just too large and you want to create a new empty log?



Gail Shaw
Microsoft Certified Master: SQL Server 2008, MVP
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #1538491
Posted Thursday, February 06, 2014 12:38 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 2:46 AM
Points: 164, Visits: 371
If you want to create a new log use sp_cycle_errorlog
Post #1538496
Posted Thursday, February 06, 2014 12:45 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, February 12, 2014 2:58 AM
Points: 14, Visits: 25
Thanks for reply to all
Post #1538498
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse