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??

Answer Wiki

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.

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

Processing your response...

Discuss This Question: &nbsp

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

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

Processing your reply...

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

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

Processing your reply...

Ask a Question

Free Guide: Managing storage for virtual environments

Complete a brief survey to get a complimentary 70-page whitepaper featuring the best methods and solutions for your virtual environment, as well as hypervisor-specific management advice from TechTarget experts. Don’t miss out on this exclusive content!

To follow this tag...

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