Errorlog auslesen

Details
Kategorie: T-SQL 
--Alle Logins mit Fehler listen
EXEC master.dbo.xp_readerrorlog 0, 1, "login", "failed", null, null, "desc"
 
--Alle backups Erfolgreich
EXEC master.dbo.xp_readerrorlog 0, 1, "backup", "successfully", null, null, "desc"
 
--Alle backups
EXEC master.dbo.xp_readerrorlog 0, 1, "backup", null, null, null, "desc"
 
--Alle backups mit Fehler
EXEC master.dbo.xp_readerrorlog 0, 1, "backup", "failed", null, null, "desc"
 
 
--Alle backups mit Fehler von bis Datum
EXEC master.dbo.xp_readerrorlog 0, 1, "backup", "failed", "2018-01-01", "2018-03-14", "desc"
 
--SPN ok?!
EXEC master.dbo.xp_readerrorlog 0, 1, "spn", Null, Null, Null, "desc"
 
--Alles
EXEC.dbo.xp_readerrorlog 0, 1, null, Null, Null, Null, "desc"

Main Menu