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 123»»»

Log Files Expand / Collapse
Author
Message
Posted Wednesday, May 21, 2014 8:29 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 10:12 AM
Points: 31,210, Visits: 15,651
Comments posted to this topic are about the item Log Files






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1573397
Posted Thursday, May 22, 2014 12:04 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 821, Visits: 1,424
The selection of answer should have been check boxes
Post #1573432
Posted Thursday, May 22, 2014 12:05 AM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 10:38 AM
Points: 13,364, Visits: 11,146
Nice one, thanks.



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1573433
Posted Thursday, May 22, 2014 12:05 AM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Today @ 4:55 AM
Points: 821, Visits: 1,424
Thanks for the question steve. The selection of answer should have been check boxes

apologies for the duplicate post
Post #1573434
Posted Thursday, May 22, 2014 12:55 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Monday, July 21, 2014 2:56 AM
Points: 2,603, Visits: 2,061
Thanks Steve for the question.

It has also been notice that Log file viewer is not displaying all the option at a time. If you open from SQL Server logs it will give you a few options, if you open from SQL Server Agent it will display some different logs, if you view log clicking data collection it will give different sets etc.


---------------------------------------------------
"Thare are only 10 types of people in the world:
Those who understand binary, and those who don't."
Post #1573444
Posted Thursday, May 22, 2014 1:07 AM


Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Monday, October 6, 2014 6:14 AM
Points: 564, Visits: 888
Thanks for the question Steve.

However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.


--rhythmk
------------------------------------------------------------------
To post your question use below link

http://www.sqlservercentral.com/articles/Best+Practices/61537/
Post #1573445
Posted Thursday, May 22, 2014 1:43 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 10:46 AM
Points: 2,644, Visits: 1,651
rhythmk (5/22/2014)
Thanks for the question Steve.
However I think version of SQL server should be mentioned in question as Remote maintenance plans can not be accessed by Log file Viewer in SQL Server 2008.


+1 that caught me out :)
Post #1573450
Posted Thursday, May 22, 2014 2:46 AM


SSCarpal Tunnel

SSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal TunnelSSCarpal Tunnel

Group: General Forum Members
Last Login: Today @ 10:35 AM
Points: 4,043, Visits: 5,360
Good one, thanks Steve...

____________________________________________
Space, the final frontier? not any more...
All limits henceforth are self-imposed.
“libera tute vulgaris ex”
Post #1573464
Posted Thursday, May 22, 2014 3:38 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 10:49 AM
Points: 1,016, Visits: 2,315
Thank you the post, SJ, simple one and nice.... but I did get it wrong.

I opened the LFV and saw these (with sub selection under each, except agent) "SQL Server", "SQL Server Agent", "Database Mail" and "Windows NT". I guess the list changes depending on the configuration or additional component installations, but the LVF has the support to log all the logs.

Microsoft SQL Server 2012 (SP1) - 11.0.3128.0 (X64) 
Dec 28 2012 20:23:12
Copyright (c) Microsoft Corporation
Developer Edition (64-bit) on Windows NT 6.1 <X64> (Build 7601: Service Pack 1)




ww; Raghu
--
The first and the hardest SQL statement I have wrote- "select * from customers" - and I was happy and felt smart.
Post #1573479
Posted Thursday, May 22, 2014 3:46 AM
SSChasing Mays

SSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing MaysSSChasing Mays

Group: General Forum Members
Last Login: Today @ 10:23 AM
Points: 650, Visits: 954
thanks for the question,

but why all answers say "only" at the end?? that's a bit confusing since no option has all the types listed in BOL.
Post #1573481
« Prev Topic | Next Topic »

Add to briefcase 123»»»

Permissions Expand / Collapse