Post reply

database maintainance

  • May 23, 2008 at 4:20 am

    #185985

    Hi,

    I am using SQL Server 2000.I have done log shipping with one server to another in which 5 databases are there.It was running successfully for last 2 months.But now it was failed as for some reason I have to restart the server.Now the job is failed showing the error

    "Executed as user: OKS-MAR\Administrator. Invalid drive specification 0 File(s) copied. Process Exit Code 4. The step failed."

    The same copy command when I run on cmd prompt it is copying but not through sql server job.

    So can u please help me out in this so that my log shipping will start again.

    Thanks

  • May 23, 2008 at 5:36 am

    #819596

    User password is expired.

    Basit Ali Farooq
    MCITP Database Administrator
    Microsoft Certified Professional Developer (Web Applications)
    Microsoft Certified Database Administrator
    Microsoft Certified Systems Engineer
    Microsoft Certified Systems Administrator
    CIW Security Analyst
    Cisco Certified Network Associate

  • May 29, 2008 at 1:20 pm

    #821965

    expired? and when an user has set password never expires? and still the same problem?

  • May 29, 2008 at 1:30 pm

    #821972

    As stated: "invalid drive specification". Has the share been removed or have permissions for OKS-MAR\Administrator to the share changed?

    -- You can't be late until you show up.

  • May 29, 2008 at 1:36 pm

    #821975

    i didn't remove or change anything.

    i can copy by cmd and i can't do it through Query Analyzer

  • May 29, 2008 at 1:50 pm

    #821985

    Whatever account starts your SQL Services seems to have had some type of permissions change. If you're not the network admin, get hold of him or her and have them help reset whatever permissions may have changed. From a cmd prompt, it's taking your network login credentials, which obviously have not changed.

    -- You can't be late until you show up.

  • May 29, 2008 at 8:39 pm

    #822066

    I agree with Terry, but want to make sure that all logshipping should have to run on SA access or SQL_SVC a/c. SQL_SVC a/c should have SA permission but login should be deny on it.

    Manoj

    MCP, MCTS (GDBA/EDA)

  • May 30, 2008 at 12:29 am

    #822121

    dlarsen (5/29/2008)

    i didn't remove or change anything.

    i can copy by cmd and i can't do it through Query Analyzer

    Copying by cmd uses your account. Copying through QA uses the SQL Server Service account. Check that that account still has the required permissions on the share and that its password hasn't expired (in Active directory) and that its account has not been locked out due to too many incorrect passwords.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • May 30, 2008 at 2:40 am

    #822146

    I agree with Gail, Manoj and Terry. Check the permissions of the SQL services accounts.



    My blog

  • May 30, 2008 at 2:43 am

    #822148

    Maybe the service account was changed for sometime but you did not restart de services. After restarting the server the account change was completed and that could be causing you problems.



    My blog

  • May 30, 2008 at 4:24 am

    #822196

    thanks a lot.

    it is solved now.

Viewing 11 posts - 1 through 10 (of 10 total)

You must be logged in to reply to this topic. Login to reply