I am trying to backup my databases from my clustered shared array to a local disk, but I can’t see the local disk when I run the Backup Wizard. Why?
This is a problem with both SQL Server 7.0 and SQL Server 2000 clustering. I don’t know if this is a bug, or there was some intentional reason for doing this. But there is at least one work-around that I am familiar with.
The work-around is to create a backup device on the local disk first, then back up to the backup device. When you create the backup device through Enterprise Manger, you will have to manually specify the path to the local drive (you can’t select it). If you create the backup device using sp_addumpdevice, there is no problem either.
Once you have created the backup device, you can backup it to it using any backup method available through SQL Server.