Hi team, here's a new case.
Problem
When a user restores the database using the SQL Server 2012 software on the Windows operating system, the software cannot read the backup data in the disk corresponding to the storage LUN.
As a result, the directory is empty.
Symptom
The customer reported that the .bak backup file stored in the Windows disk where the storage LUNs are mapped cannot be read when the database is restored using the SQL server 2012.
After you click the directory, you can view all the .bak files in the directory, as shown in the following figure.
Cause
The direct reason why the directory cannot be accessed is that the user MSSQLSERVER used by the SQL server does not have the permission to access the folder where the backup files are stored.
By default, the new folder can be accessed. It is suspected that the customer has shared the folder with the backup file. The authorization of the folder is damaged during backup. Even if the sharing is canceled, the authorization of the MSSQLSERVER user cannot be restored. Therefore, the MSSQLSERVER user cannot access the shared folder.
Location Method
1. Click Start.
2. Right-click My Computer and choose Computer Management from the shortcut menu.
3. Choose System Tools > Event Viewer > Windows Logs > System, and check whether the following err error event exists, indicating that the permission of the sql.svc user is incorrect.
Workaround
Method 1: Create a folder that has not been shared to store backup files.
Method 2: Add the NT SERVICE\MSSQLSERVER user to the file access list and grant corresponding permissions, as shown in the following figure.
Post-Recovery Check
Use Windows SQL Server 2012 to restore data and check whether the .bak file can be accessed.
