August 11, 2009 at 5:28 pm
When I attempt to add a "New Backup Device" and browse to a drive that is not the default "Backup" location (R:\Microsoft SQL Server\MSSQL.1\MSSQL\Backup in this case), I am unable to see any drives except "R:" in the "Locate Database Files" window. I'm trying to backup to a drive which is a cluster resource that is online and which shows up under My Computer on the node it is currently owned by and can be browsed to, etc. There are other disks configured as cluster resources but the only disk visible in "Locate Database Files" is the drive specified as the SQL Data drive during installation.
I am able to successfully backup to the R: drive. but I want to use the T: drive as my Backup device/location.
The ACL looks the same on the T: drive as it is on the R: drive so I don't see a security problem
If I manually enter the path to the T: drive in the File box in the new backup device dialog then a backup device is set up under Server Objects -> Backup Devices in Mgmt Studio and I can select that backup device as the destination backup device but the backup fails.
Shouldn't the other local drives be visible in the "Locate Database Files" window?
Thanks
August 11, 2009 at 5:54 pm
The SQL Server resource needs to be dependent upon the drive resources so that SQL Server can 'see' them. If the drives are not resources in the same resource group as SQL Server - they need to be added, then you need to take the SQL Server resource offline and add the disk resources to the SQL Server resource.
The other option is to just use the UNC share name instead, which would be: \\{cluster resource ip/name}\t$\{backup folder}
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 11, 2009 at 5:59 pm
Thanks for the response. How would I go about in doing this? I ran cluster admin and did not see anything listed. This cluster was setup by a vendor years ago and they did not leave any documentation behind.
Thanks again
August 11, 2009 at 6:05 pm
From cluster admin - find the group that has SQL Server as a resource. It will be the group that also has the R: drive as a resource.
Add all of the disk resources you need in that same cluster group.
Take the SQL Server resource offline - NOTE: THIS WILL BRING SQL SERVER DOWN AND THE DATABASE WILL NOT BE ACCESSIBLE.
Access the properties of the SQL Server resource, and select the dependencies tab. On that page, add the disk resources you setup in the above step.
Bring the SQL Server resource back online.
The disk drives you have added will now be visible to SQL Server and available for use.
Again, you don't have to have the disk resource available to SQL Server to use it for backups. You can use the UNC path in the backup.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
August 12, 2009 at 4:01 pm
Thanks for the response. Now I'm having an issue adding a physical disk via the command line using the cluster command, I'm getting a system error 87. The drive that I wanted to add is a local drive with RAID 5 configurations. This is the kb article from MS that I used to do this:
http://support.microsoft.com/kb/555312
The second step is where it comes back with the error 87. I'm attaching excerpts from another admin that is having the exact issue:
Hi,
I have configured Majority Node Cluster with two servers.
now I want to add Physical Disk Resource, so for that I used Cluster Administrator
but when I started new resource and follow all steps with next.... next then at the end in DISK Option. It will appear totally blank and I can not complete that procedure.
secondly, I tried with command prompt with following command.
c:\>cluster res "Physical Disk E:" /create /group:"Cluster Group" /type:"Physical Disk"
It will completed successfully but when I saw that resource property then found all drive letter (C: D: E: ) in that field.
afetr that I run
c:\>cluster res "Physical Disk E:" /priv Drive="e:"
but it will failed with below error
System error 87 has occurred (0x00000057).
The parameter is incorrect.[/i]
Any ideas? I know this is no longer related to SQL backups but is more a cluster disk adding question.
Thanks
August 12, 2009 at 10:12 pm
I am not sure about the problems you are having with the disks. I don't setup clusters since I am a DBA - but I do not know how you are got SQL working in an MNS cluster. As far as I know, SQL Server is not supported on that configuration.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply