Browsing articles in "SQL Server Agent"
Jul
15
2016

Transaction log file full because of log_reuse_wait_desc=replication, CDC, goldengate

Came across weird situation where received alert for SQL Server transaction log file full and found log_reuse_wait_desc=replication from sys.databases   Now before mentioning troubleshooting step, setup of the database is question is little bit complex because Database is part of SQL Server replication where database publisher is at vendor side and we don’t have access to publisher DB 🙁 Oracle Golden Gate replication is configured from this database to Oracle DB Database in question is […]

Sep
24
2013

Info – SQL Server Proxy accounts and job agent execution contexts

SQL Server proxies are used in cases where impersonation is required in complex and secured environments and more control is required while executing packages, jobs, PowerShell commands etc. below links and details are collected to give more info on this topic, it requires a good amount of reading and may take up to 2-3 hours to understand it completely, so be patient if you land on this page and go through all links and articles […]

Apr
16
2013

Fix: Issue with SQL Agent not coming up due to agent error log path incorrect

SQL Server Agent was unable to come up and no error was being reported (only error we found as “SQL agent services started and then stopped”, nothing was logged in Event viewer as well), hence was unable to identify the actual error with which agent was failing, following is done to fix it,   1. Ran following command to read agent error log using query analyzer,                                 EXEC sys.xp_readerrorlog 0,2                 Output was: Msg 22004, […]

Dec
25
2012

SQL Agent service stopping due to a stop request from a user process or the os…

On SQL Server 2008 R2 RTM edition faced issue that SQL Agent is not coming up, following errors noticed when services started via SSCM (SQL Server Config Manager) console and via SSMS (SQL Server Mgmt Studio), SSCM: SSMS:   In Agent Error logs, following was found, —— 2011-11-29 13:28:30 – ? [310] 4 processor(s) and 8192 MB RAM detected 2011-11-29 13:28:30 – ? [339] Local computer is xxxxx running Windows NT 6.1 (7601) Service Pack […]

Oct
25
2012

SQLServer Error: 17750, Could not load the DLL xpstar90.dll

Environment: SQL Server 2005 x64 SP3 Issue: While checking a SQL Agent status, found it stopped and when tried to start it is giving following error, The SQL Server Agent (MSSQLSERVER) service on Local Computer started and then stopped. Error: When checked SQLAgent error log file SQLAgent.out (generally located at: %ProgramFiles%\Microsoft SQL Server\<InstanceName>\MSSQL\Log\ or you can check the location of error logs in the startup parameters in advanced tab of SQL services or in Windows […]

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

View Post by Categories

%d bloggers like this: