November 18, 2009 at 4:43 am
I have a SQL 2000 cluster running on Windows 2003 Enterprise server, the cluster shared storage is provided by a Dell SCSI disk array.
Im trying to backup the databases to an ISCSI drive on our SAN. When I select the backup locations for the databases in the maintenance plan the server only shows 2 drives (R & S) which are on the Dell expansion box, all other drives are not visible (local drives c: and d:, quorum drive q: - also on the Dell disk array and finaly x: ISCSI drive on our SAN)
Can anybody tell me why these drives are not available to select as backup locations and how to add them.
Thanks in advance
November 18, 2009 at 1:57 pm
That sounds strange. Can you manually type in the path to the location on the SAN where you want to backup the databases to?
Does the account you're creating the maint plan under have permissions on all of those drives?
Joie Andrew
"Since 1982"
November 18, 2009 at 5:55 pm
SQL Server does not know about non-clustered resources when it is running on a cluster, because it can only see the resources allocated to the virtual server. To be able to perform a backup to any drive you will need to either add that drive as a cluster resource or refer to the drive using a UNC path.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply