Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

cluter server databases backup on local drive Expand / Collapse
Posted Saturday, March 13, 2010 7:16 AM


Group: General Forum Members
Last Login: Wednesday, December 30, 2015 11:01 AM
Points: 107, Visits: 880
I have a SQL 2005 cluster running in vms on VMware ESX 3i.

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?

Shivrudra W
Post #882356
Posted Saturday, March 13, 2010 9:34 AM



Group: General Forum Members
Last Login: Today @ 5:18 AM
Points: 45,619, Visits: 44,147
When dealing with a cluster, only shared drives that are dependencies of the SQL Server service are accessible from SQL Server

Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

We walk in the dark places no others will enter
We stand on the bridge and no one may pass

Post #882375
Posted Saturday, March 13, 2010 10:24 AM


Group: General Forum Members
Last Login: Thursday, November 24, 2016 7:36 AM
Points: 2,316, Visits: 4,349
You can place the backups file anywhere but to refer by drive letter, the drive must within the SQL Server resource group. You can reference using UNCs in the format of \\servername\sharename\(directory) where directory is optional.

Note that you must use Cluster Administrator to define the share and the security. The share needs to belong to a resource group that has a Network Name, an IP and a dependency to the physical disks.

SQL = Scarcely Qualifies as a Language
Post #882385
Posted Saturday, March 13, 2010 6:49 PM
Old Hand

Old HandOld HandOld HandOld HandOld HandOld HandOld HandOld Hand

Group: General Forum Members
Last Login: Thursday, April 23, 2015 1:05 AM
Points: 381, Visits: 368
Yes, as others said drive should be in SQL server service resource group, check with windows team they can fix this for you.

Post #882443
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse