Backup failed

  • We are taking backup on to data domain but its failing for 2instace and in another instance its working fine i have checked every permission of service account everything is given but here the strange thing the backup is running automatically after sometime.

    see below error

    Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp...".: 100% complete End Progress Error: 2012-08-27 03:14:53.41 Code: 0xC002F210 Source: Back Up Database Task Execute SQL Task Description: Executing the query "failed with the following error: "xp_create_subdir() returned error 161, 'The specified path is invalid.'". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly. End Error Error: 2012-08-27 03:14:53.93 Code: 0xC002F210

  • Hi Santosh,

    The error is clearly mention path is invalid please cross check the path & manually execute the job...

    ---

    Satish

  • Thanks for replay but i have checked the path and its fine even i am trying to take the backup manually but its not worked

  • What's the backup statement?

    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
  • Its an maintenance plan and running with below query

  • You said you tried to take the backup manually. What was the backup statement, what was the exact error?

    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
  • I was trying to take the backup from GUI

    When i selected the path the error i am getting is "can not verify the existence of the backup location do you want to use backup location anyway"

    i selected yes once after this when i clicked on ok the error i getting is

    can not open Backup device '--------.trn' failed to create. Operating system error 1326(Logon failure: unknown user name or bad password.). [Policy: MSSQL Logfile Template]

  • santhosh411 (8/27/2012)


    I was trying to take the backup from GUI

    When i selected the path the error i am getting is "can not verify the existence of the backup location do you want to use backup location anyway"

    i selected yes once after this when i clicked on ok the error i getting is

    can not open Backup device '--------.trn' failed to create. Operating system error 1326(Logon failure: unknown user name or bad password.). [Policy: MSSQL Logfile Template]

    Try to take the backup to some local disk. I believe that you are taking the backup to some network resource where you do not have the permission for your id.

    If you get the error when taking the backup on local disk, post it here.


    Sujeet Singh

  • In local disk its working fine but i want to take this backup into data domain

  • for the permission i have logged through service domain account and i have tried but no luck same error is coming

  • santhosh411 (8/27/2012)


    for the permission i have logged through service domain account and i have tried but no luck same error is coming

    Make sure that sharing permissions have been set correctly on the network share where you want to take the backup. Also, check the SQL Server service account, is it set to local system or any such built-in system account?


    Sujeet Singh

  • (Logon failure: unknown user name or bad password.)

    You're using an account that does not exist on the domain or you're specifying an incorrect password. If you're using a domain account, check that the password hasn't been changed. If you're using a local server account, use a domain account instead.

    This isn't a permissions problem, it's an authentication problem, AD is rejecting the username or password.

    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
  • Issue got resolved automatically...

    But i am not understanding why the job is failing and this happening once in a month

Viewing 13 posts - 1 through 12 (of 12 total)

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