Results 1 to 6 of 6
  1. #1
    Join Date
    Apr 2004
    Posts
    64

    Unanswered: NLB drainstop command issues

    Hello,

    We use the NLB drainstop command to gracefully move connections from one database server (server A) to another (server B) but we discovered with one application in particular that the connections stay alive on the server A.

    The applications make DB connections using standard .NET System.Data classes.

    Has anyone experienced this before? Any pointers on what to check for?

    Thanks

    Alex

  2. #2
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    which database is this?

    you have posted in the non-database-specific "database concepts" forum, and it sounds like this thread should be moved to a database-specific forum
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  3. #3
    Join Date
    Apr 2004
    Posts
    64
    Thanks. I'll post it in the sql server forum.

  4. #4
    Join Date
    Apr 2004
    Posts
    64

    NLB drainstop command issues

    Hello,

    We use the NLB drainstop command to gracefully move connections from one database server (server A) to another (server B) but we discovered with one application in particular that the connections stay alive on the server A.

    The applications make DB connections using standard .NET System.Data classes.
    The database servers are SQL Server 2005.

    Has anyone experienced this before? Any pointers on what to check for?

    Thanks

    Alex

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    no, don't do that, we'll just move this thread over there

    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  6. #6
    Join Date
    Apr 2004
    Posts
    64
    Quote Originally Posted by r937
    no, don't do that, we'll just move this thread over there

    Hehe!! Thank you sir!

    I hope someone here can assist!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •