Backup failed

Question

Post reply

Backup failed

santhosh411

Ten Centuries

Points: 1155
More actions
August 27, 2012 at 5:03 am

#265933

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

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

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

saidapurs Hall of Fame Points: 3477 More actions · Answer 1

Hi Santosh,

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

---

Satish

santhosh411 Ten Centuries Points: 1155 More actions · Answer 2

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 3

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

santhosh411 Ten Centuries Points: 1155 More actions · Answer 4

Its an maintenance plan and running with below query

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 5

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

santhosh411 Ten Centuries Points: 1155 More actions · Answer 6

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]

Divine Flame SSCoach Points: 15943 More actions · Answer 7

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

santhosh411 Ten Centuries Points: 1155 More actions · Answer 8

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

santhosh411 Ten Centuries Points: 1155 More actions · Answer 9

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

Divine Flame SSCoach Points: 15943 More actions · Answer 10

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

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 11

(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

santhosh411 Ten Centuries Points: 1155 More actions · Answer 12

Issue got resolved automatically...

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