SQL Server Performance Forum – Threads Archive
urgent help needed on log shipping
hi guys,p log shippong yesterday on production environment. i started the services SQL+Agent with a domain account and give rights on shared folders. It seems that the sql server service on tha main server stopped and was unable to start again.
we had to restart it manually
Also it seems that the log backup has not been coppied to the secondary server
please help AKTHAR
Check the password for that user account and ensure applied on the Windows –> Adminstrative tools –> Services –> SQLAgent service. Also check what is the error you are getting when trying to start. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
hi ,
the windows account and password are good
no error when i manually start the service AKTHAR
i mean the sql server service start with no error. But when i start the sql agent service it stops with error: "sql agtent service start but then stopped…" AKTHAR
Are you using same account for SQL Server & SQLAgent services??
Check the SQLagent log in this case why it is getting stopped. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
yes same account for both services AKTHAR
What is your sql build? https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=206727&wa=wsignin1.0
MohammedU.
Moderator
SQL-Server-Performance.com All postings are provided “AS IS†with no warranties for accuracy.
ok guys,
i have figured out what the problem is . Infact the sql service start before the newtork interface so it doen not find the domain controller.
Can i used some script to start it once the server is properly started. AKTHAR
Is thishttp://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=22050 related for same issue. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.
]]>