Fix MS SQL Server Error 15105 [Best Solutions]
“How to fix SQL Server error 15105” This technical article carries a reliable solution to this user query. So, if you’re looking for a way to resolve this error, you’ve come to the right place.
As we know, SQL Server is a proprietary relational database management system (RDBMS) developed by Microsoft (MS). It is a software application that mainly has the primary function of storing, managing, and retrieving data. However, users may encounter SQL Server Error 15105, which can disrupt normal database operations. In this post, we will explore both manual and professional solutions to fix this error.
Potential Reasons Behind SQL Error 15105
The error code 1515 in SQL Server has been attributed to problems with input/output. When the SQL Server service account lacks permission to access or write on a given file specifically, this condition characterises it. Possible reasons and resolutions of SQL Server error 15105 include:
- Insufficient Permission
- File / Folder Path Issue
- Network Share Permission
- Drive Space
- SQL Server Account Change Issue
- Antivirus or Security Software
Solution 1: Manual Solution to Tackle Error 15105 SQL Server 2008 r2
Before moving forward with the manual approach, it is crucial to verify that there is sufficient space available on the drive where your data files are stored.
Procedure to fix SQL Server error 15105 2008 r2:
Step 1. First, navigate to the original folder location on the shared network.
Step 2. Choose the “sharing and security” option by right clicking on the folder.
Step 3. Find the “permission setting” button under the sharing table and click on it.
Step 4. Give the account you’re using for backup full access permission.
Attention : Limit the duration of these permissions if needed
Step 5. Once you’ve added the account, click “apply” and then select “OK”.
Step 6. On the security tab, include all relevant accounts and give them the right privileges.
Step 7. First, press “apply” and then click “OK” to save the changes.
That’s all about the manual process for resolving the error 15105 SQL Server backup. Although this method is simple, it has some drawbacks. It can be long and time-consuming, especially for non-tech users.
Solution 2: Professional Solution to Resolve SQL Server Error 15105
If the manual method fails to fix SQL error 15105, then opt for the SQL Database Recovery Tool. It is one of the finest solution that help you to fix this issue without having any trouble. Additionally, it allows users to preview and recover SQL Server objects such as – tables, triggers, stored procedures, functions, tables, views, and more.
Moreover, the software provides three different options such as – SQL Server database, SQL Server compatible SQL Scripts, and CSV file format to export data. Also, the utility is capable enough to recover lost or deleted SQL databases from MDF & NDF files without facing any issues.
Step-by-step procedure to fix SQL Server Error 15105 2008 r2 with this professional tool:
Step 1. Install and run the tool on your desktop and hit the “open” to add the master database file (MDF).
Step 2. Thereafter, select the scan mode and choose the SQL Server version. Also, check the recovered deleted object dialogue box and then enable it.
Step 3. Preview all the database objects and press the “export” option.
Step 4. Now, select the “export to/ as” option and fill up the required details.
Step 5. Lastly, click on the save/export button to tackle SQL Error 15105 error.
Also Read: How to Repair Corrupt MDF File in SQL Server Database?
Concluding Words
In this post, we discussed how to fix SQL Server error code 15105. We covered two approaches – manual & professional. However, the manual method is complex as we saw. On the other hand, the automated solution works perfectly to resolve the error without any limitations. Moreover, it is also recommended by well-known IT experts. Hence to resolve the error 15105, the automated solution is the best answer.