SQL Server Performance

urgent help needed on log shipping

Discussion in 'SQL Server 2005 Log Shipping' started by Akthar, Jun 7, 2007.

  1. Akthar New Member

    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
    Akthar, Jun 7, 2007
    #2

  2. satya Moderator

    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.
    satya, Jun 7, 2007
    #2

  3. Akthar New Member

    hi ,
    the windows account and password are good
    no error when i manually start the service

    AKTHAR
    Akthar, Jun 7, 2007
    #2

  4. Akthar New Member

    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
    Akthar, Jun 7, 2007
    #2

  5. satya Moderator

    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.
    satya, Jun 7, 2007
    #2

  6. Akthar New Member

    yes same account for both services

    AKTHAR
    Akthar, Jun 7, 2007
    #2

  7. MohammedU New Member

    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.
    MohammedU, Jun 7, 2007
    #2

  8. Akthar New Member

    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
    Akthar, Jun 7, 2007
    #2

  9. satya Moderator

    satya, Jun 11, 2007
    #2

Share This Page