Running an application on the passive node?

Posted on 2011-04-21
Last Modified: 2012-05-11
I have an SQL Cluster with a DB-Active and DB-Passive node. DB-Active is running at around 30% capacity. On my dev server I can run the DB and application without a problem.
So my questions are can I run the application on the passive node?
If yes then do I need to be cautious of anything?

I know that if the DB-Active fails then it flips to DB-Passive and it should continue to process.
Also that if DB-Passive fails, then my application cannot be run until it is back online.

Question by:n2dweb
    LVL 142

    Accepted Solution

    >So my questions are can I run the application on the passive node?

    the question is in how far does it depend from the db/cluster?
    LVL 1

    Author Comment

    It is an application that runs automatically based upon triggers in the DB. When new input is received from a client, then it processes the data and writes the results to the DB.
    The App server then picks up these results and creates a report for the client.
    LVL 1

    Author Comment

    So the answer is still a "Yes"?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    So every once in a while at work I am asked to export data from one table and insert it into another on a different server.  I hate doing this.  There's so many different tables and data types.  Some column data needs quoted and some doesn't.  What …
    In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
    Sending a Secure fax is easy with eFax Corporate ( First, Just open a new email message.  In the To field, type your recipient's fax number You can even send a secure international fax — just include t…
    Get a first impression of how PRTG looks and learn how it works.   This video is a short introduction to PRTG, as an initial overview or as a quick start for new PRTG users.

    779 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    14 Experts available now in Live!

    Get 1:1 Help Now