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.




Related Articles :

  • No Related Articles Found

No comments yet... Be the first to leave a reply!

Software Reviews | Book Reviews | FAQs | Tips | Articles | Performance Tuning | Audit | BI | Clustering | Developer | Reporting | DBA | ASP.NET Ado | Views tips | | Developer FAQs | Replication Tips | OS Tips | Misc Tips | Index Tuning Tips | Hints Tips | High Availability Tips | Hardware Tips | ETL Tips | Components Tips | Configuration Tips | App Dev Tips | OLAP Tips | Admin Tips | Software Reviews | Error | Clustering FAQs | Performance Tuning FAQs | DBA FAQs |