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 5, 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 5, 2014 11:33 PM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 12:43 AM
Points: 635, Visits: 1,155
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 6, 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 @ 1:36 AM
Points: 42,488, Visits: 35,556
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 6, 2014 12:38 AM
SSC-Enthusiastic

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

Group: General Forum Members
Last Login: Wednesday, June 18, 2014 2:55 AM
Points: 179, Visits: 387
If you want to create a new log use sp_cycle_errorlog
Post #1538496
Posted Thursday, February 6, 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