question

ramesh 1 avatar image
ramesh 1 asked

sql server 2005 drive issue

hi , unable to access the drive in the sql server. we have 3 drives S,T,U drives, i am able to access then in windows environment,but when i am trying to take backup from sql server , i am unable to see the drives , and also i am unable to access then , other than S drive.
sqllinked-serverserver
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

2 Answers

·
Scot Hauder avatar image
Scot Hauder answered
What account is the SQLAgent running under? Changing this to use a domain account that has access to the drives should make them visible
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Pavel Pawlowski avatar image Pavel Pawlowski commented ·
+1 and if SQL server/agent is runnung under domain accout, check rights of that account
0 Likes 0 ·
ramesh 1 avatar image ramesh 1 commented ·
we have a seperate domain account create with admin rights , use use cluster server
0 Likes 0 ·
Matt Whitfield avatar image
Matt Whitfield answered
If you are running on a cluster, then SQL Server will only see the disk resources that are in the same cluster group, and that it is set as a dependency of - because that is the only way that it can ensure that the drives will actually always be on the same node and ready when the service starts. Also, I don't know why you've tagged your question 'linked-server'? Some more information about your environment might make it easier to give an answer...
2 comments
10 |1200
Toggle Comment visibility. Current Visibility: Viewable by all users

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.

Matt Whitfield avatar image Matt Whitfield ♦♦ commented ·
Right, so make sure that the disks you want to use are in the same cluster group, and make sure that they are set up so that SQL server is dependent on them. Then they will show up...
1 Like 1 ·
ramesh 1 avatar image ramesh 1 commented ·
yes we are using them on cluster and the resources are shared on the same server
0 Likes 0 ·

Write an Answer

Hint: Notify or tag a user in this post by typing @username.

Up to 2 attachments (including images) can be used with a maximum of 512.0 KiB each and 1.0 MiB total.