Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 Database Design and Application Architecture
 Clustered and non-clusterd database on the same se

Author  Topic 

jleb
Starting Member

3 Posts

Posted - 2011-04-04 : 08:17:47
Hi,

I have a server with a clustered database instance on it, and another database instance "non-clustered".
My problem is when the server reboot, my cluster and the clustered database restart with success, but my non clustered instance is not starting even if my non-clustered instance service is automatic.

I don't know why the non-clustered instance is not starting. An idea ?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-04-04 : 11:24:28
You'll need to look in the Event log.

Why would you want a non-clustered instance on a cluster?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

jleb
Starting Member

3 Posts

Posted - 2011-04-04 : 12:02:23
My purpose is to mutualise the server and my non clustered databases have not to be clustered...

I haven't install the clustered database and found what was the problem.
My non-clustered databases used the same drive the clustered one...
Thanks
Go to Top of Page

Jahanzaib
Posting Yak Master

115 Posts

Posted - 2011-04-16 : 01:00:27
Both are different NAMED instance ? and check the service account of the instance

Check also in the SQL Server configuration Manager the port of the sql service should be different

Clustered is 1433 then Non-Clustered should be like 1434,1435,.....etc

Regards,

Syed Jahanzaib Bin Hassan
MCTS,MCITP,OCA,OCP,OCE,SCJP,IBMCDBA

My Blog
www.aureus-salah.com
Go to Top of Page

jleb
Starting Member

3 Posts

Posted - 2011-04-18 : 03:10:13
Thanks for your reply,

I found the problem...
My collegue used the same drive for clustered and non clustered databases...
The non-clustered databases can't start withouit the drive... We create a dependancy between the non-clustered instances and the cluster services and it solved my problem.
Go to Top of Page
   

- Advertisement -