October 11, 2006 at 8:35 am
When we installed the cluster we added 6 SAN drives to the cluster. The local drive was not added as a node. Originally, we thought we would kepp backups on local drive but when we started we figured out that the local drive, not being part of cluster, is not visible to Enterprise Manager.
I assume it has to be added to cluster to make it available for EM. Is there a way, we can get the drive recognised without making it a part of cluster.
Please advise.
Regards,
Madiha.
October 12, 2006 at 5:54 am
You don't want the local drive to be part of the cluster. The reason is that when server one fails or is not part of the active SQL Server you will not be able to access it. If you have databases on that drive they will become suspect. The whole point to clusters is that the drives that the databases are on are seperate from the physical servers so all nodes in the cluster can access them.
October 12, 2006 at 8:09 am
You can back up to local drives on a clustered system, by running the backups from T-SQL
BACKUP DATABASE msdb
To Disk = 'c:\backups\msdb.bak'
will work, but you must remember that the physical location of the C drive will be the local drive of whichever cluster node is the owner of the Virtual SQL server resorce group at the time the backup is executed. So you might have to go looking to find your backups.
hth jg
October 12, 2006 at 8:36 am
Also, don't forget... if you do that and THAT specific server dies you have NO backup. That is the dangerous part.
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply