Oct
7
2013

Fix: Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)

When trying to take Microsoft SQL Server database backup to a network shared disk then receiving following error,

 

 

Error text: Cannot open backup device “\\xxxxxxxx\xxxx.bak” . Operating System Error 5 (failed to retrieve text for this error. Reason: 15105). (Microsoft.SQLServer.Smo)

 

The error may vary, you may also receive Operating system error 5(Access denied) and that too for local disk instead of network disk. But symptom is same.

 

Solution to fix this issue,

 

1. Go to network share (where the actual folder is shared)

2. Right click and go to “Sharing and Security…” option, click it

3. Go to “Sharing” tab and then click permissions settings,

 

4. Give Full access privilege to the account which is taking backup (if running under SQL server service account context then give full privileges to the domain account), if you are not much concerned on security for the activity then give full privileges to EVERYONE temporarily and once activity is complete revoke it

 

5. After adding necessary accounts and privileges, click Apply and OK

 

6. Now go to “SECURITY” tab, add all accounts to whom you have given access permissions in STEP 4 and give them FULL Control or write privileges as deemed necessary, if not concerned for security then give EVERYONE account full control for the activity and then revoke later

 

7. Once done click Apply and then OK

 

8. Now try to take backup, it should happen successfully.

 

Hope this solves issue!

 

References:

http://stackoverflow.com/questions/11178536/create-file-encountered-operating-system-error-5failed-to-retrieve-text-for-thi

http://stackoverflow.com/questions/2398385/sql-server-2008-backup-error-operating-system-error-5failed-to-retrieve-text

http://social.msdn.microsoft.com/Forums/sqlserver/en-US/1ee3dc8e-e11d-431d-9fa8-cfce93a968d9/failed-to-create-operating-system-error-5failed-to-retrieve-text-for-this-error-reason-15105?forum=sqldisasterrecovery

Download PDF

About the Author: Nitin G

Indian born, trekker, biker, photographer, lover of monsoons. I've been working full time with SQL Server since year 2005 and blogs to post the content aquired during my research on new topics or fixing issues faced by me as a DBA while working in different kind of projects, hope some of my posts may helps others in SQLDBA community. Everything you read on my blog is my own personal opinion and any code is provided "AS-IS" with no warranties!

8 Comments + Add Comment

  • Many thanks for sharing this, it has solved the problem with backing up our database, without having to change the service account being used by SQL server.

    • Thanks Sangeeta, glad it solved your issue.

  • Thanks, work in different case, but similiar, thanks a lot.

  • I had the same error and solved by allocating more space to the destination directory. try that.

    • Turns out that mine was because the database and backup location were both located on mount points. As soon as the database was mounted from a local location instead of the mount point the backups went through straight away. Cheers

  • Well tried to explain in short, voted as “yes”. Here this article also described broadly the term SQL Server Error 15105. http://sqltechtips.blogspot.com/2015/12/backup-error-15105.html

  • I have the same error message but i am not saving to a network share. In fact my SQL DB is stored on a different disk and accessed with a mount point. The backup location is another separate disk accessed with a different mount point.

    If i back up to a local disk it works fine. This error only started happening recently and before this it worked fine.

    Any ideas?

  • Thanks 🙂

Leave a comment

Subscribe to this blog via Email

Enter your email address to subscribe to this blog and receive notifications of new posts by email.

Join 24 other subscribers

Translate this blog!

EnglishFrenchGermanItalianPortugueseRussianSpanish

Calender

October 2017
M T W T F S S
« Sep    
 1
2345678
9101112131415
16171819202122
23242526272829
3031  

View Post by Categories

%d bloggers like this: