January 4, 2010 at 11:39 am
Hi,
When I go to the "management" folder to view the sql server logs, the size of the log file is too big that I'm not able to view it. Is there a way to switch the log file so it generates a new log file without bounce the sql server?
Thank you in advance for your help.
January 4, 2010 at 11:54 am
Are you referring to the Transaction Logs, or the SQL Event Logs?
Andrew SQLDBA
January 4, 2010 at 11:55 am
The question seems to be a wrong one. You don't shrink SQL Server log file, you recycle it. You shrink a Database transaction log File.
Use
EXEC sp_cycle_errorlog
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 11:59 am
Exactly
I did not want to give advice until he was clear about what was needed. Some people do get the logs confused
Andrew SQLDBA
January 4, 2010 at 12:06 pm
Right I agree !
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 4:01 pm
I meant "SQL Server Logs", not transaction logs. I am not sure where you get the SQL Event logs. Under the "Management" folder, there is a folder called "SQL Server Logs". Under the "SQL Server Logs", there is a list of them. I clicked the right mouse button on one of them and selected "View SQL Server Logs". Hope this help.
January 4, 2010 at 5:14 pm
You seem to mixing up the terminology again.
There is SQL Server Error Logs and Windows Event Log and what is that you are interested in viewing? If it is SQL Server Information? Then you got to view SQL Server Logs.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty
January 4, 2010 at 5:43 pm
I believe this article will help you
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
January 5, 2010 at 11:43 am
Hi Jason,
A BIG THANKS. I reviewed the URL that you provided it and this is what I need. My co-worker and I applied it and the size of the file is reduced tremendously.
January 5, 2010 at 11:49 am
You're welcome.
Sidenote: You will find that the assistance will be more accurate and much quicker with more precise terminology and detail.
I am glad that I could be of assistance.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply