Error: Login failed for user ‘NT AUTHORITY\ANONYMOUS LOGON’. Reason: Token-based server access validation failed with an infrastructure error. Source Logon Message Error: 18456, Severity: 14, State: 11. Note: This error seems to happen when trying to query the database using SQL Server Manager Studio (SSMS) on a remote computer. This error does not happen when... » read more
uspDbaIndexDefrag xx_dba_indexDefragStatus xx_dba_indexDefragExclusion xx_dba_indexDefragLog
Should schedule during off hours. Type: Transaction-SQL script (T-SQL) Database: master Command:
This job should be ran weekly or monthly. Not recommended to run daily as it can take a long time. Type: Transaction-SQL script (T-SQL) Database: master Command:
SQL job to remove bak files older than 2 days for a folder. Type: PowerShell Run as: SQL Server Agent Service Account Command:
Error: SQL Error 601. Could not continue scan with NOLOCK due to data movement. SQL Sever Logs: Message Error: 605, Severity: 21, State: 3. Message Attempt to fetch logical page (13:2769683) in database 7 failed. It belongs to allocation unit 72057594291945472 not to 72057594369933312. Explanation This error generally signifies page or allocation corruption in the... » read more