473,809 Members | 2,710 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

SQL Database Mirroring and the Session State Database

We have a number of databases mirrored including the ASPState session
database used by the websites. However the connection string to the
ASPState database does not allow you to include the 'Failover Partner =
ServerB' parameter, and it does require you to have the 'Data Source =
ServerA' parameter. (Where ServerA = Principal, ServerB = Secondary.)
Normal databases that allow you to have 'Failover Partner' parameter
work great.

How is possible to ensure that the ASPState database fails over or is
available if Server A goes down to ensure the continous operation of
the web application? The problem being that the Session connection
string has the server specified when the other db's have switched to
server B.

It is preferred but not essential that sessions remain intact - surely
there must be a workaround for this?

(Apologies for cross-post but I think this issue may have a .NET
resolution as much as SQL Server...)

TIA,
S.

Jun 26 '06 #1
1 2529
Don
Hi There,

Did you get your problem solved? I got same issue here, we have couple of
web application on .net 1.1, recently we migrated to sql 2005 db with
mirroring on couple of dbs, however, connectionstrin g does not like "Failover
Partner"

Thanks
Don

"Calculated " wrote:
We have a number of databases mirrored including the ASPState session
database used by the websites. However the connection string to the
ASPState database does not allow you to include the 'Failover Partner =
ServerB' parameter, and it does require you to have the 'Data Source =
ServerA' parameter. (Where ServerA = Principal, ServerB = Secondary.)
Normal databases that allow you to have 'Failover Partner' parameter
work great.

How is possible to ensure that the ASPState database fails over or is
available if Server A goes down to ensure the continous operation of
the web application? The problem being that the Session connection
string has the server specified when the other db's have switched to
server B.

It is preferred but not essential that sessions remain intact - surely
there must be a workaround for this?

(Apologies for cross-post but I think this issue may have a .NET
resolution as much as SQL Server...)

TIA,
S.

Sep 20 '06 #2

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
1157
by: Scott Vercuski | last post by:
Hello all, I've got a question about session state. Is it possible to declare and load a session into a session object from the sql server database. Here's the scenario ... I've got a website using SqlServer as the session state manager. I've got a web service that I'd like to pass in the SessionID and have it load the session from the database. I'd just like to know if this is possible.
4
2331
by: Jeff | last post by:
We have multiple ASP.Net web apps in development. As a standard we are looking to go with SQL Server to hold state information. Can we have the multiple apps all point to a single State DB? Or do we need to install multiple instances of the State database on to the SQL Server (one for each Web app)? It would seem that you could run into troubles pointing several web apps at the same DB, because you would introduce the possibility (a...
5
6234
by: d.grabov | last post by:
Can anyone offer some advice on how to reduce the size of a database log. The database is mirrored on another server using the logs. Thanks
0
4403
by: serge | last post by:
I have 2 SQL Enterprise Editions running SP2 and same collation. When i try to start database mirroring I get the following error message: "The remote copy of database "ABC" has not been rolled forward to a point in time that is emcompassed in the local copy of the database log. (Microsoft SQL Server, Error: 1412)" Both SQL Server services are running under account
0
3068
by: umeshpotdar | last post by:
i am doing mirroring on the data base i have done every step but i got problem below "Database Mirroring Transport is disabled in the endpoint configuration." this problem occured when i cilck on the "start mirroring" button can anybody know about mirroring
5
5869
by: bosko19 | last post by:
We have recently set up two SQL Server 2005 Standard Edition servers with database mirroring. The mirrors function and fail over without a problem, but the Database Mirroring Monitor Job fails every time with the following error message: Incorrect syntax near '.'. (Error 102) Incorrect syntax near the keyword 'with'. If this statement is a common table expression or an xmlnamespaces clause, the previous statement must be terminated...
0
1646
by: vishnutd4u | last post by:
Hi friends, This is vishnu.Here in our company we have decided to implement database mirroring in mysql.Database mirroring means just when one database server is down the backup database server will take over database server's work just thats i know.But i dont know how to implement that thing.So plz if any one knows help me step by step of implementing in this matter.I am working on VC++ which is on window based(client side).But mysql...
6
2444
by: DNB | last post by:
I would like to know what you guys think is the best way to access data: Asp.Net session vs. Database Queries. In our application we are using asp.net tree view to display hierarchical data and when user clicks on particular node it brings up totally different page with all the asp.net controls dynamically generated. Example: Tree view Control is as follow:
3
1415
by: =?Utf-8?B?RHVrZSAoQU4yNDcp?= | last post by:
We are setting up a web farm and want to store session state on a SQL Server 2005 Enterprise sp2 database. But when the web sites try to access the session state we get the error... Unable to use SQL Server because ASP.NET version 2.0 Session State is not installed on the SQL server. We installed the custom state database using... aspnet_regsql -S mysvrname -E -ssadd -sstype c -d mydbname ....and can see the database.
0
9603
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can effortlessly switch the default language on Windows 10 without reinstalling. I'll walk you through it. First, let's disable language synchronization. With a Microsoft account, language settings sync across devices. To prevent any complications,...
0
10640
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers, it seems that the internal comparison operator "<=>" tries to promote arguments from unsigned to signed. This is as boiled down as I can make it. Here is my compilation command: g++-12 -std=c++20 -Wnarrowing bit_field.cpp Here is the code in...
0
10376
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
10387
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
1
7662
isladogs
by: isladogs | last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM). In this session, we are pleased to welcome a new presenter, Adolph Dupré who will be discussing some powerful techniques for using class modules. He will explain when you may want to use classes instead of User Defined Types (UDT). For example, to manage the data in unbound forms. Adolph will...
0
6881
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
5689
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4332
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
3861
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.