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
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 Application start dependent on SQL recovery

Author  Topic 

YellowBug
Aged Yak Warrior

616 Posts

Posted - 2008-07-24 : 04:02:58
I am running Microsoft SQL Server 2005 SP2 Standard Edition (64-bit) on Windows Server 2003.

I have some applications that have a resource dependency on the
SQL Server and
SQL Network Name
resources, in Cluster Admin.

After fail-over, SQL Server starts. The application attempts to connect before the database recovery is complete. And fails.
How do I tell the application to wait until recovery is complete?
What dependency should I set?

Thanks in advance

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-24 : 14:01:25
You may need build that check in app.
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2008-07-24 : 14:01:48
There is no dependency to set in the cluster for this.

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

Subscribe to my blog
Go to Top of Page
   

- Advertisement -