Solved

Backup failed

Posted on 2012-03-30
11
603 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 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
What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

 

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
 

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

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Amazon RDS migrate to SQL Server 3 50
Compare a column in results by values left of decimal 2 34
Split string into 3 separate fields 5 36
SQL profiler 3 51
In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
The Email Laundry PDF encryption service allows companies to send confidential encrypted  emails to anybody. The PDF document can also contain attachments that are embedded in the encrypted PDF. The password is randomly generated by The Email Laundr…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

752 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