Today I came across an issue on one of my windows server disk space was getting full rapadely.
Then I analyzed my servers disk space by tool called Free Disk Analyzer. I found that my SQL Servers Log folder was crossing the limit and ERRORLOG was growing in GB's.
You can download this Tool from here as well. Free Disk Analyzer .
Then first question came in my mind, Can I delete this directly?
Then Second question was is it Safe to do that?
By default SQL Server stores seven ERRORLOG files named as below
ERRORLOG
ERRORLOG.1
ERRORLOG.2
ERRORLOG.3
ERRORLOG.4
ERRORLOG.5
ERRORLOG.6
In my SQL Server 2008 R2, ERRORLOG files are located in the "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log" folder. The ERRORLOG file contains the latest information and the ERRORLOG.6 file contains the older information.
My ERRORLOG files has grown too large in size, later I found a Stored Procedure to cycled the ERRORLOG file manually from the SQL server New Query window.
sp_cycle_errorlog .
The data in the ERRORLOG files will be overwritten to ERRORLOG.1 file, you can make a copy of this old ERRORLOG.1 files to some external media if they are required for future reference.
It is now safe to delete the big size files.
Hope this helps...
Then I analyzed my servers disk space by tool called Free Disk Analyzer. I found that my SQL Servers Log folder was crossing the limit and ERRORLOG was growing in GB's.
You can download this Tool from here as well. Free Disk Analyzer .
Then first question came in my mind, Can I delete this directly?
Then Second question was is it Safe to do that?
By default SQL Server stores seven ERRORLOG files named as below
ERRORLOG
ERRORLOG.1
ERRORLOG.2
ERRORLOG.3
ERRORLOG.4
ERRORLOG.5
ERRORLOG.6
In my SQL Server 2008 R2, ERRORLOG files are located in the "C:\Program Files\Microsoft SQL Server\MSSQL10_50.MSSQLSERVER\MSSQL\Log" folder. The ERRORLOG file contains the latest information and the ERRORLOG.6 file contains the older information.
My ERRORLOG files has grown too large in size, later I found a Stored Procedure to cycled the ERRORLOG file manually from the SQL server New Query window.
sp_cycle_errorlog .
The data in the ERRORLOG files will be overwritten to ERRORLOG.1 file, you can make a copy of this old ERRORLOG.1 files to some external media if they are required for future reference.
It is now safe to delete the big size files.
Hope this helps...
3 comments:
Stainless steel tip design for Titanium Gr 5/5 - The Titanium
If you love ford ecosport titanium stainless steel tip designs, you can make an alloy for your table top, or make an alloy camillus titanium for 2018 ford fusion energi titanium your suppliers of metal patio or patio. This is the perfect Rating: 5 · 1 review · $7.99 · In stock titanium wallet
t835a7mpjre855 cheap nfl jerseys,wholesale jerseys,wholesale nfl jerseys,Cheap Jerseys china,Cheap Jerseys free shipping,wholesale jerseys from china,Cheap Jerseys china,wholesale nfl jerseys,cheap jerseys,wholesale jerseys from china k392s4hfmtb434
gd612 joma eesti,fly london stivali,cariuma tenis,salomon stockholm,marc fisher shoes,armanicolombia,mou eskimo sneakers,fabletics sneakers,armani beauty belgique dy679
Post a Comment