Restore DB

Question

Restore DB

SQLRNNR

SSC Guru

Points: 281334
More actions
July 8, 2010 at 12:41 pm

#234892

Active / Active Clusters
SQL 2008
Windows 2008 R2
I get the following error message when using the GUI to try and restore (this happens for each of the nodes in the Active/ Active Cluster)
I have verified that the Service Account running SQL Server has permissions to the LUN. I have also verified that my account has permissions to the LUN. I can execute the following from within SSMS:
EXEC master.dbo.xp_cmdshell 'dir e:\ /s'
The execution of that query does provide a full directory output.
I can see the LUN from explorer and have been able to place a test file there to confirm access.
I have not confirmed but I suspect that I can restore the databases via script since I can run the dir from SSMS.
Any thoughts on what may be causing this in the GUI?
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 1

Is the E drive a cluster resource? Is it set as a dependency of the SQL Server resource?

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 2

I knew I forgot to add some information

Yes that LUN is a Cluster resource and is a dependency for SQL Server. SQL Server will not start if I leave that resource offline.

I can also offline the SQL group and it will take the LUNs offline. If I move the SQL Cluster, all LUNS will move with it.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

SQLRNNR SSC Guru Points: 281334 More actions · Answer 3

GilaMonster (7/8/2010)
Is the E drive a cluster resource? Is it set as a dependency of the SQL Server resource?

K - lesson learned. The drive was not listed as a dependency for SQL Server. Triple check dependencies in the future and don't just rely on stop/start, move, offline of the SQL Cluster.

Thanks Gail.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 4

*edit* Never mind.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 5

This is for our QA environment and I found out that somebody from the server team had removed the LUN dependencies while I was on vacation this last week. What a pain.

Thanks again Gail.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Gail Shaw SSC Guru Points: 1004504 More actions · Answer 6

CirquedeSQLeil (7/8/2010)
This is for our QA environment and I found out that somebody from the server team had removed the LUN dependencies while I was on vacation this last week. What a pain.

Slap the culprit with a SQL manual when you find him please. Removing the dependency would have required taking SQL offline and back online. It's not something you can do by accident.

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

SQLRNNR SSC Guru Points: 281334 More actions · Answer 7

GilaMonster (7/8/2010)
CirquedeSQLeil (7/8/2010)
This is for our QA environment and I found out that somebody from the server team had removed the LUN dependencies while I was on vacation this last week. What a pain.
Slap the culprit with a SQL manual when you find him please. Removing the dependency would have required taking SQL offline and back online. It's not something you can do by accident.

Just another one of those slaps. It has been happening a bit more lately. I know who it is too.

Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events

Perry Whittle SSC Guru Points: 234013 More actions · Answer 8

on a Windows 2008 cluster, you do not have to take the SQL Server service resource offline when removing a disk dependency!

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉