Solved

Backup failed

Posted on 2012-03-30
11
577 Views
Last Modified: 2012-04-26
I have the maintenance plan  for the daily full backup and log backup . It has  failed for last two days. the error in the logs shows the following message

BackupDiskFile::CreateMedia: Backup device '\\mnsql01\sqlbackups\mnncdbprod01\full\rgsdyn_backup_2012_03_29_201531_3880704.bak' failed to create. Operating system error 86(The specified network password is not correct.).

I don;t know anything has changed (at least one body informed me). Can you suggest what should i do . How to fix the issue so that it won;t fail today?

Thanks
0
Comment
Question by:manojbaba
  • 7
  • 2
  • 2
11 Comments
 
LVL 10

Expert Comment

by:Casey Herman
ID: 37787903
Not sure what backup system you are using but it looks like the service account for that backup is either locked or the password has changed.

Casey
0
 
LVL 10

Expert Comment

by:pclinuxguru
ID: 37787947
Last time I saw an error like that our NAS's computer account had to be re-added to AD because it wasn't authenticating properly.

You can try going to:
\\mnsql01\sqlbackups\mnncdbprod01\full\

from the SQL server and see if you can access the folder.
0
 

Author Comment

by:manojbaba
ID: 37788002
Thanks Casey,

The account that runs the services is dedicated domain  service account . and when i  check the account properties it  is not locked. I am not sure whether someone changed the password or not but most probably not because it is used by all the services..

Suppose if the  password  were changed does it affect the backup process. ?
0
 

Author Comment

by:manojbaba
ID: 37788125
Thanks pclinuxguru,

I can access the folder from the sql server machine.but I am using my domain account to access the  \\mnsql01\sqlbackups\mnncdbprod01\full\ folder.

 And the other backup jobs  from different  sql server with different service account is also working  to the  same NAS  location , I don;t why it is failing.  

If we re add NAS's computer account had to AD  don;t it affect the other process currently running.

Thanks
0
 
LVL 10

Expert Comment

by:pclinuxguru
ID: 37788182
More than likely. If it works from other places then something else is wrong.

In SQL Studio do you have anything under backup Devices?
0
Complete Microsoft Windows PC® & Mac Backup

Backup and recovery solutions to protect all your PCs & Mac– on-premises or in remote locations. Acronis backs up entire PC or Mac with patented reliable disk imaging technology and you will be able to restore workstations to a new, dissimilar hardware in minutes.

 

Author Comment

by:manojbaba
ID: 37788232
there is nothing under backup Devices.
0
 
LVL 10

Accepted Solution

by:
Casey Herman earned 500 total points
ID: 37789020
You will get a login error like above.  Depending on how locked down your service account is you can test it by creating a simple scheduled task to open notpad or something with the known password and see if the job runs. If it doesnt than the password has been changed.  Also you should check to see if password policies are allowed to affect that account.  If you are 100% sure what the password should be you can reset the password to the known password again and it should work.

Casey
0
 

Author Comment

by:manojbaba
ID: 37803729
Thanks casedog21

Sorry, I was on vacation for few days . The jobs is still failing. I changed the owner of job to sql server agent account and  I also changed the ownersid  of sysssispackages as well in according to new account. this doesn't help.

Then I tried to create the new maintenance plan  with one backup job? but it also failed.

When i see the security of the NAS folder( \\mnsql01\sqlbackups\mnncdbprod01)  all the account i used has full control permission. I don;t know what wrong with this server.


Thanks


I am going to check in reply soon and I will add that too soon.
0
 

Author Comment

by:manojbaba
ID: 37803785
I tried  with what you said it opens the notepad file.
0
 

Author Comment

by:manojbaba
ID: 37816683
The problem hasn't solved yet when  the check the permission on the shared folder in the NAS server. the service account used by sql server agent has full permission  and i run the job by same account.

I even tried to run the simple backup job from the query editor  using same and  different account separately having read/writhe permission on the  NAS folder and sysadmin right in the sql server gives the same error.

Cannot open backup device ''\\mnsql01\sqlbackups\mnncdbprod01\full'. Operating system error 1326(Logon failure: unknown user name or bad password.).
0
 

Author Comment

by:manojbaba
ID: 37825230
The problem is solved there the service account password was changed,
0

Featured Post

PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

Join & Write a Comment

Suggested Solutions

After restoring a Microsoft SQL Server database (.bak) from backup or attaching .mdf file, you may run into "Error '15023' User or role already exists in the current database" when you use the "User Mapping" SQL Management Studio functionality to al…
SQL Server engine let you use a Windows account or a SQL Server account to connect to a SQL Server instance. This can be configured immediatly during the SQL Server installation or after in the Server Authentication section in the Server properties …
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
You have products, that come in variants and want to set different prices for them? Watch this micro tutorial that describes how to configure prices for Magento super attributes. Assigning simple products to configurable: We assigned simple products…

759 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

18 Experts available now in Live!

Get 1:1 Help Now