WITH LOG is possible, don't forget that . Only a member of the sysadmin fixed server role or a user with ALTER TRACE permissions can specify WITH LOG. In production you would have to wrap the WITH log generating code in a stored procedure properly signed.

Jan 8, 2012 · In SQL server instance(s) I manage; I see a lot of activity and messages in SQL server error log for e.g. backup or transaction log backup completed etc..

Nov 16, 2019 · The ones that are stored in the C:\Program Files\Microsoft SQL Server\MSSQL12.MSSQLSERVER\MSSQL\Log folder. – MiscellaneousUser Commented Nov 16, 2019 at 17:45

Feb 22, 2019 · Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Jan 2, 2013 · It's worth noting that sp_cycle_errorlog only recycles ONE log file. But because there are 7 files, if you really want to purge them and save space (as I did) you will need to run the command several times (7 times to be exact).

Nov 7, 2014 · Stack Exchange Network. Stack Exchange network consists of 183 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

CREATE TABLE #error_log ( log_number INT, log_date DATE, log_size INT ); INSERT #error_log ( log_number, log_date, log_size ) EXEC ( 'EXEC sys.sp_enumerrorlogs;' ); SELECT * FROM #error_log AS el; Then set up a loop to grab the max log number, only grab logs after a certain date, or perhaps exclude logs based on size.

See a lot of SQL Server login/logon failure message come through here. This is my attempt to start a dialog with good answers to have a single point of reference for folks.

Whether it's logged or not, the behavior is different in pre-2012 and 2012+. Before SQL Server 2012, to get checkpoint logging you'd have to turn on a trace flag (T3504). But starting in SQL Server 2012 that message is logged by default when a long checkpoint is encountered.

Oct 29, 2014 · In SQL Server Management Studio, in Object Explorer > Management, there is a setting if you right click on SQL Server Logs and select Configure.