I'm trying to setup a Backup Maintenance Plan in SSMS for Sql Server 2012, running in a failover cluster on Windows Server 2012. The current plan backs up to the same cluster volume where the database data and transaction log files reside, and I want the backups going to a different volume, but the only volume that I can select in the maintenance plan configuration is the shared drive I am already using. The same limitation exists when I try to manually run a backup from within SSMS - I can only see the one drive.
How can I get additional drives to show up?
- Mapped the new cluster volume to a drive letter
- Ensured that the sql server service account has full control permissions on that drive
- Successfully run a backup to the new drive using T-sql
In the long term, I fully intend to move to t-sql scripted backups for the additional control and flexibility, but I'm new to this and want to get the backups on a separate drive right the heck now.