SQL Server 2005 with SAN storage problem

5 pts.
Tags:
SAN
SAN storage
SQL 2005
SQL Server 2005
i have a very strange problem: - i have an  windows 2003 server - a SAN storage attached to that server - i installed SQL server 2005 proffesional into the server - database files in the san storage - when i attach the database into the san storage it gives an error that it cann't see the drive E san drive buit into the cluster when i press OK it shows the drive normally and i attach the database succefully - the magic is when i restart the server the sql server lose the access to the files and i need to deatach the database and reattach it any ideas??

Software/Hardware used:
IBM Server and SAN Storage
ASKED: December 19, 2010  10:20 AM
UPDATED: December 20, 2010  3:01 PM

Answer Wiki

Thanks. We'll let you know when a new response is added.

What SQL is clustered you need to ensure that the SQL Server instance is dependent on shared disks within the cluster manager. If it isn’t then you won’t be able to attach the databases on those disks.

Stop the SQL Service, right click the SQL Server resource within the cluster manager and select properties. Select the Dependencies tab and add in any missing disks. Click ok then restart the SQL Server.

Discuss This Question:  

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following