We have a clustered SQL server, and the backups of the databases are stored on the same drive where the data files are(F:). The storage team finally acted on my request to have a new clustered drive solely for SQL backups(G:). When I try to backup the database on the backup folder on the new clustered drive I get an error:
Cannot access the specified path or file on the server. Verify that you have the necessary security privileges and that the path or file exists.
If you know that the service account can access a specific file, type in the full path for the file in the File Name control in the Locate dialog box.
I have already:
- Assigned the cluster disk to SQL Server in WSFC
- Added the SQL Server service account in the Security on the disk properties, and has been inhereted by the children
- Changed the database settings on the instance properties to have the new path for backup
Is there anything else that i missed? I still cant backup to the new clustered disk. Does this process require a server restart?