No Failover And Client Crashes ODBC DSN Setting For Failover In Connection String

Mar 3, 2007

We have set up Mirroring with a witness server and everything works fine when we failover from the SQL Management console.

However, if we failover when our Maccola client is connected, the client blows up - clearly because it can no longer connect to the database.

The ODBC DSN used by the Maccola client shows a checkbox for the 'select a failover server' but the checkbox is grayed out.

Also the summary of settings for the DSN at the end of the wizard reveals that the failover to server (y/N) option is set to N.

The default setting for this DSN is 'populate the remaining values by querying the server' but it doesn't appear to be getting the settings for failover from the server or any other interactive DSN settings either. The server is clearly set for mirroring.

Another suspicious item is that the DSN cannot connect to the server with SA permissions, even though the server is set to mixed security and we use the correct authentication.

Is it possible that the client MACHINE is not authenticating with the domain or sql server properly. We are logged into the client with the domain account that is the SQL admin account on the sql server box.

We should be able to interact with the sql server settings through the ODBC DSN on the client shoulnd't we?

Are we missing a service pack on the client?

Thanks,

Kimball

View 1 Replies


ADVERTISEMENT

SQL Server Admin 2014 :: AlwaysOn Failover Cluster Session Failover

Oct 29, 2015

1. Once fail over to secondary replica, what will happen to connected session in primary node? can the session fail over to secondary seamlessly or need to re-login. what happen committed transactions which has not write to disk.
2. Assume I have always on cluster with three nodes, if primary fails, how second node make write/ read mode.
3. after fail over done to 2nd secondary node what mode in production(readonly or read write).
4. how to rollback to production primary ,will change data in secondary will get updated in primary.

View 5 Replies View Related

Recovery :: AlwaysOn Failover Cluster And Active Sessions Failover Scenario

Oct 29, 2015

1. In alwaysON fail over cluster, Once fail over to secondary replica, what will happen to connected session in primary node? can the session fail over to secondary seamlessly or need to re-login. what happen committed transactions which has not write to disk.

2. Assume I have always on cluster with three nodes, if primary fails, how second node make write/ read mode.

3. After fail over done to 2nd secondary node what mode in production(readonly or read write).

4. How to rollback to production primary ,will change data in secondary will get updated in primary.

View 3 Replies View Related

Client Failover Problems

May 25, 2006

Hi,

I encountered 2 problems when my application reconnects to the mirror database after the principle database is not available.

My Connection String:

Data Source=ServerA;Failover Partner=ServerB;Initial Catalog=TestFailover;Persist Security Info=True;User ID=sa;Connect Timeout=45

Firstly, the following exception will be prompted when failover occurs:

A transport-level error has ocurred when received results from the server. The specified network name is no longer available

Q1: Is it normal to have this exception? Otherwise, how can I avoid this exception?

Secondly, I tried to capture the exception and retry the operation, then failover successed but the time is very slow. A simple update operation takes about 2 mins to complete which can be finished within a second under normal situation. I tried to set the Connect Timeout to 30s, but the application pending for long long time.

Q2: How can I improve the time need for failover?

View 3 Replies View Related

Error After Db Failover If Client App Already Connected To Db

Apr 7, 2008

The following looks very much like the problem reported for the JDBC driver.

http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=688897&SiteID=1
https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=191767

----------------------------

I've written a small VB .Net app using Visual Studio 2005 to test mirroring from the client's perspective.

I have a button that does the following: 1) opens a connection to a sql 2005 database (SP2), 2) uses the connection, 3) closes the database connection.

After running this code, but while the client app is still running, I failover the database to the failover partner.

When click my button again, I get the following error: "An error has occurred while establishing a connection to the server. When connecting to SQL Server 2005, this failure may be caused by the fact that under the default settings SQL Server does not allow remote connections. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified)". Checking the Event log on what is now the mirror, I see a string of "18456 Login failed for user 'testuser'"

If I close the app and launch it again, it does the right thing (and connects to the new primary). Also, instead of closing/re-opening the app, if I wait long enough (e.g. 10 minutes), then try again, it connects successfully to the new primary. Finally, instead of closing/re-opening the app if I tweak the connection string (e.g. change the application name) then try to connect again, that also works.

Based on articles I've read online, I've disabled the connection pool in my connection string, but that didn't solve my problem (although I'm getting a different error than if pooling is on).

Here is the connection string I am using:

Data Source=DB1PACS,12345;Failover Partner=DB2PACS,12345;Pooling=False;Initial Catalog=PACSTest_Client;Integrated Security=No;User ID=testuser;Password=*****

Here is the code snippet that I run before and after the failover. Based on the fact that I'm not using Pooling, the ClearAllPools() if overkill. Any help would be appreciated; I've been researching this for days without luck.

I can keep clicking the button that runs this code, and it keeps failing. If I wait long enough (e.g. 10 minutes) and then click the button again, it works. Or I could quit/restart the app, or tweak the connection string.

Dim TestClient_Connection As New SqlClient.SqlConnection(txtConnectionString.Text)

If Me.DataGridView1.Rows.Count > 0 Then Me.Test_ClientDataSet.Clear()

Try

TestClient_Connection.Open()

Me.User_TTableAdapter.Connection = TestClient_Connection
Me.User_TTableAdapter.Fill(Me.Test_ClientDataSet.User_T)

TestClient_Connection.Close()
TestClient_Connection.Dispose()
SqlConnection.ClearAllPools()

Catch sqlex As SqlClient.SqlException

txtErrorMessage.Text = "Error State: " _
+ sqlex.Errors.Item(0).Number.ToString _
+ " Message: " + sqlex.Message

End Try


Similar to the JDBC driver article I mentioned, when using the connection string above (where DB1 is the principal and DB2 is the failover partner) if DB2 is the actual principal when I initially query and close the database connection, then after failover to DB1 my application reconnect just fine.


Thanks

View 8 Replies View Related

Recovery :: Error When Setting Up Failover Cluster

Aug 26, 2015

I'm getting the following error when I go to create a cluster in the Failover Cluster Manager in Windows Server 2008.

"The address 10.10.10.111 is not valid for its associated network"

I'm following the instruction in the book for the 70-462 exam.  There was a step that had me create a DNS A record for the address sql-cluster.contoso.com.  The IP address was mapped to 10.10.10.111.  I'm not sure if this is the culprit but its the only time I used that IP address in the setup.

Below are 2 screenshots.  The first screenshot is the error.  The second screenshot is my DNS console.

View 7 Replies View Related

Recovery :: Add Client Software To Failover Cluster?

Jul 17, 2015

The main objective is to have a third party program operate on a failover cluster.  The OS is Windows Server 2012 Datacenter loaded on 2 nodes. A virtual node exists along with supporting disks. This client software uses a SQL Server database.  SQL Server 2012 Enterprise is installed and operating in a failover environment.  However the client software is not failing over. If the connection to node A is lost, SQL Server fails over to node B.  But the client application does not. 

What needs to occur in order to associate the client software with the failover cluster?  This software has 6 services total installed. Some are referred to as servers - looks like to communicate between remote client computers and the database. What is the process to associate the client software with the failover?

View 6 Replies View Related

Connecting To Failover Partner Using ODBC And OLE DB

May 24, 2006

I need to connect to mirrored SQL servers (Developer Edition) using OLE DB, I tried both OLE DB and ODBC, but it doesn't work



I used connection ODBC string:



Driver={SQL Native Client};Server=10.0.1.161;Failover Partner=10.0.1.162;Uid=test;Pwd=test;Database=TestDB



if server 161 is principal and server 162 mirror, it connects ok, but
when I exchange server roles, connect fails (the error message is:
Cannot open database "TestDB" requested by the login. The login failed.
in LOGIN)



the connect string using OLE DB is:

Provider=SQLOLEDB.1;Persist Security Info=False;User
ID=test;Password=test;Failover Partner=10.0.1.162;Initial
Catalog=TestDB;Data Source=10.0.1.161;Use Procedure for Prepare=1;Auto
Translate=True;Packet Size=4096;Use Encryption for Data=False;Tag with
column collation when possible=False

error message is the same



when I try to connect using VS 2005 using connection string
Database=TestDB;User Id=test;Password=test;Server=10.0.1.161;Failover
Partner=10.0.1.162, it works OK



i have installed SQL server 2005 (on local - client machine) with SQL Native Client and also

SQL Server service pack 1



Is there any way how to connect from OLE DB?

Thanks

View 3 Replies View Related

Client Failover Takes 1 To 3 Minutes After Database Has Failed Over

May 12, 2008



We are having problems getting the ADO.NET client to failover in a timely manner in a web application. Here's what happens:

1) Database fails over in 3 to 5 seconds
2) Clients attempt to login to primary and receive SQL server not available errors
3) The clients slowly start to connect and succeed without errorson the secondary.
4) We are still see SQL Server login errors on the primary, even after the failover
5) When we failback to the primary, it all happens within a few seconds (no problems)

If we recycle IIS, this problem goes away

Here's what we have tried
1) Turning off connection pooling (has no effect). We also can see the connections get killed on the primary server
2) Applying this hotfix (http://support.microsoft.com/kb/944099)

And yes, we are running a script to sync up the SIDS so that doesn't appear to be a problem. What seems to be happening is the primary server is getting stuck in the ADO.NET application memory. The problem is we don't know how to fix it.

BTW, our hardware is SQL Server 2005, Windows Server 2003, .NET 2.0 (and .NET 3.5)

Let me know if you need additional information. Thanks in advance

View 2 Replies View Related

SQL Native Client Automatic Failover Only Works When Both Servers Are Plugged In

Dec 9, 2006

I have setup a database mirroring session with witness - MachineA is the principal, MachineB is the mirror, and MachineC is the witness. Each SQL Server instance is hosted on its own machine. The mirroring is working correctly. If I submit data to the database on MachineA, and then unplug the network cable on MachineA, MachineB automatically becomes the principal, and I can see the data that I originally submitted to MachineA on MachineB. All the settings are showing correctly in Management Studio.

My issue is with the SQL Native Client and a front-end application that needs to make use of this database. I have setup my front-end application to use the ODBC client and specified the failover server in both the ODBC setup and the connection string. Here is the connection string that I am using :

Provider=ODBC;Database=master;DSN=MachineA;Failover Partner=MachineB;

Everything works perfectly on my front-end application when MachineA is the principal. If I unplug the network cable on MachineA, MachineB becomes the principal, and the failover occurs correctly on the database side. The problem is that my front-end application is not able to query the database on MachineB.

BUT - if I plug the network cable back in on MachineA (making the database on MachineA the mirror), the front-end application now works and can access the principal database on MachineB. I wrote a quick tester application to verify what I am seeing, and I am convinced that this is what is happening. The mirroring is working perfectly, and everything is setup correctly. The SQL Native Client is setup correctly. The problem is that the automatic failover to MachineB that is built into the SQL Native Client only works if both servers are plugged in.

In this scenario, when I plug both servers in, I know that the front-end app is definitely pulling from MachineB (since the mirror database on MachineA is in recovery mode, it's unavailable, and the front-end app displays the server that it is pulling data from).

Am I using an out-dated SQL Native Client? The version number displayed in the ODBC configuration page is 2005.90.2047.00, and is dated 4/14/2006. Has anyone experienced this issue? I'm guessing that it's a problem in the SQL Native client, since the mirroring really seems to be working correctly.

Thanks,

Bill

View 13 Replies View Related

Failover Takes Long Due To Connection Blocking

Mar 27, 2007

We are using SQL Server 2005 mirroring with the witness server.

In most cases whenever a failover was triggered we saw it happen in a matter

of a few seconds. However, the last time it took about 15 minutes - we suspect

due to Connection being blocked.

Would appreciate any information on what could cause this?



We have 2 databases that run on the server.



View 2 Replies View Related

DSNLess Connection With Failover On SQL Server 2005 Cluster ?

Nov 20, 2006

Hi,

We have configured two SQL Server 2005 in a cluster (without Witness).

We have severals ASP (using ADO) that are connecting to SQL Server 2005 with SQL Native Client in a DSNLess connection String :

driver={SQL Native Client}; server=MAINMAIN; Failover Partner=BCKUPBCKUP; uid=log;pwd=pwd;database=MyBase

When using this connection string, the connection to MAIN is alrigth, but when we simulate a unavailability situation on "MyBase" or on the entire MAIN instance, the new connection are joining the MAIN and not the BCKUP SQL Server.

We tryed several Connection Strings including Failover_Partner, Initliag Catalog instead of database... but no one succed in joining the BCKUP SQL Server.

I precise that the DNS on the PC that connect to SQL server is configured and both MAIN and BCKUP are resolved in command line or in explorer.

Is there an other driver that must be used, or is there an other parameter to set in the connection string ?

Regards.



View 1 Replies View Related

DSNLess Connection With Failover To A SQL Server 2005 Cluster

Nov 20, 2006

Hi,

We have configured two SQL Server 2005 in a cluster (without Witness).

We have severals ASP (using ADO) that are connecting to SQL Server 2005 with SQL Native Client in a DSNLess connection String :

driver={SQL Native Client}; server=MAINMAIN; Failover Partner=BCKUPBCKUP; uid=log;pwd=pwd;database=MyBase

When using this connection string, the connection to MAIN is alrigth, but when we simulate a unavailability situation on "MyBase" or on the entire MAIN instance, the new connection are joining the MAIN and not the BCKUP SQL Server.

We tryed several Connection Strings including Failover_Partner, Initliag Catalog instead of database... but no one succed in joining the BCKUP SQL Server.

I precise that the DNS on the PC that connect to SQL server is configured and both MAIN and BCKUP are resolved in command line or in explorer.

Is there an other driver that must be used, or is there an other parameter to set in the connection string ?

Regards.

View 1 Replies View Related

Can't Find SQL Native Client In ODBC Connection Manager In SQL Server Open Database Connectivity (ODBC)

Feb 13, 2007

I apologize if this is not the correct forum for this posting. Looking at the descriptions, it appeared to be the best choice.

I am running Windows XP Pro SP2. I have installed the SQL Native Client for
XP. However, when I try to add a new data source through ODBC Connection
Manager, SQL Native Client is not listed as an option. I have followed this procedure on three other systems with no problems. What would be causing the
SQL Native Client to not show up in the list of available ODBC data sources?

View 4 Replies View Related

Error When Setting Up ODBC Connection

Dec 12, 2005

Hi I downloaded MSDE2005 and I tried to set up an ODBC connection to adatabase I created. I can see the database using client but I got thiserror through the ODBC manager[Microsoft][SQL Native Client]An error has occurred whileestablishing a connection to the server. When connecting toSQL Server 2005, this failure may be caused by the fact thatunder the default settings SQL Server does not allowremote connections.Can anyone, please tell me what I need to do to get this setup? I triedto dabble with the TCIP and remote setting but nothing worked.Regards

View 1 Replies View Related

Seeing Duplicate SQL Servers, When Setting Up ODBC Connection

Mar 1, 2006

When setting up an ODBC connection on a non-sql Server X and choosing from the drop down menu which SQL Server to connect to, I see two identical names for my SQL Server (Y). No matter which one I choose, Im not able to go to the screen after being asked how I want to log in (SQL server authentication)

If I build a ODBC connection from any other desktop, I only see one SQL Server Y, and am able to establish a connection to SQL Server Y, with the same user account and password as when Im on Server X.

Server X has two network cards and is teamed...could that be a possible problem ?

Any ideas ?...Thank you

View 7 Replies View Related

ODBC Connection Not Terminating After Client Diconnects

Jan 9, 2001

Hi,

We have SQLSERVER 7.0 in one of the production.
The clients r connected thru ODBC.
The clients doesn't gets disconnected after a task result in
increase in sqlserver log.

Can anyone advice me .

Thanks in advance
Anu

View 2 Replies View Related

ODBC Connection Issue On Client Site

Jun 7, 2007

Hi,
I am not sure if I select right Froum:)
It might be a basic question but could you please help me on that?



Working Environment:



I have developed application on SQL Server 2005 and now wants to Run on Client Site, I am using access as a front end and SQL server 2005 back end through ODBC (System Dsn) which is working good. (user has been added on SQL Server and on Database)



Question:

1) Do I need to create new System Dsn Or other DSN (Keep in mind I have already create System DSN in Server) at each client site to access application from Server?

(If yes then I am trying to do that, it allow me to create (with required database which is on Server) and verify but doesn’t save on ODBC list so I can’t use that name to run appliation on client site)



I am using windows authentication.



Thanks for help in advance



AA

View 4 Replies View Related

ODBC Connection Issue On Client Site

Jun 7, 2007

Hi,


It might be a basic question but could you please help me on that?

Working Environment:

I have developed application on SQL Server 2005 and now wants to Run on Client Site, I am using access as a front end and SQL server 2005 back end through ODBC (System Dsn) which is working good. (user has been added on SQL Server and on Database)

Question:
1) Do I need to create new System Dsn Or other DSN (Keep in mind I have already create System DSN in Server) at each client site to access application from Server?
(If yes then I am trying to do that, it allow me to create (with required database which is on Server) and verify but doesn€™t save on ODBC list so I can€™t use that name to run appliation on client site)

I am using windows authentication.

Thanks for help in advance





View 1 Replies View Related

Help On Setting Up Connection String

Sep 20, 2006

I'm using VWD on SQL2005EXPRESS And i keep getting a connection string errorCan someone show me how to put  a connection string in the web.config, or which connection string to use to connect to my host database which they're running SQL2000..Thanks Newbie

View 9 Replies View Related

ODBC Connection For Client Application To SQL Server 2005 Express Installed On Network Computer

May 5, 2006

Hi All,

I've developed an application that connects to a SQL Server 2005 Express database. I created a DSN to connect to the database through ODBC. Currently, I am testing locally and everything works fine.

I would now like to install my application on another workstation and connect remotely to the database located on my development machine.

The client workstation does not have SQL Server 2005 Express installed on it because I would just like my application to connect remotely by creating the DSN and using ODBC. What I'm missing here are the database drivers. The "SQL Natice Client" is not available on this client workstation. How can I deploy the necessary drivers with my installation file so that I may create the required DSN name using the SQL Native Client driver?

Thanks!

View 6 Replies View Related

Setting OLEDB Connection String With Variables

Feb 1, 2007

I am trying to set the connection string in a connection manager at runtime. Here is what I have done:

1. Created a gv_DataSource, gv_Username and gv_Password

2. Created a ForEach Loop that reads DataSource, Username and password values from a variable (it is an For Each ADO loop Enumerator). The ADO recordset is read into by an Execute SQL task before the loop.

3. Mapped values from the recordset to variable in the ForEach loop's "Variable Mappings" page.

4. Used the variables in my Sybase OLEDB Connection Manager's "Expression" property, setting the "ConnectionString" property to:

"Data Source=" + @[User::gv_DataSource] + ";User ID=" + @[User::gv_Username] + " ;Password=" +
@[User::gv_Password] + ";Initial Catalog=blue;Provider=Sybase.ASEOLEDBProvider.2;Persist Security Info=True;"

5. I set the values in my database table for the connection-I set 2 connections for which I have Sybase OLEDB datasources setup.

When I run the package, I just get the first server's data twice, it doesn't set the second server's data during the second loop. I made sure the first one was working (i.e. the ConnectionString's property was being set by the data from the current variables) by setting the variables incorrectly in the variable properties page, and then running the package. So the first row of connection information is working, but the second loop around it doesn't seem to be working. I used a msgbox in a script task to show that the variables are mapping correctly in the loop, so it seems the second time around the connection information isn't taking from the variables.

What am I doing wrong here?

Thanks,

Kayda



View 1 Replies View Related

SQL Native Client Connection String Problem

Oct 18, 2006

Hi,

I have two server instances of SQL on my server MYSRVR: default (SQL 2000) and named SQLX (SQL 2005).

I've been using these strings ok for the default (SQL 2000):

"Server=MYSRVR; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

"Server=192.168.1.128; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

and these for the named (SQL 2005)

"Server=MYSRVRSQLX; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

"Server=192.168.1.128SQLX; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

But then adding the SQL port 1433 works for the default:

"Server=MYSRVR,1433; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

"Server=192.168.1.128,1433; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

But this, for named (SQL 2005) actually connects to default. The SQL port is causing the name SQLX to be ignored.

"Server=MYSRVRSQLX,1433; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

"Server=192.168.1.128SQLX,1433; Database=mydb; Network=dbmssocn; Integrated Security=SSPI "

Anyone any ideas?



View 5 Replies View Related

Dynamically Setting Connection String Depending On Server_name?

Apr 18, 2008

I need to make my site aware of which server_name it is loading from so it uses a different connection string. (have dev + prod servers for web/sql)Currently my connection string is in web.config as follows:  <connectionStrings>      <!-- Development and Staging connection string -->          <add name="myconnection" connectionString="server=myserver; user id=mysuer; password=mypassword; database=mydatabase" />   </connectionStrings> I need to make sure the 'name' is the same for both connection strings since that is how the rest of my site looks for it.  However, I'm not sure how to get both in here with some sort of 'if/then' statement to determine which one to use.I've heard it could be done in global.asax with something similar to the code below, but I dont know how to assign a 'name' to a connection string for that type of setup. Sub
Session_OnStart  ServerName =
UCase(Request.ServerVariables("SERVER_NAME"))  IF ServerName = "prod.server.com" THEN   ...Set Prd string...  ELSE   ...Set Dev string...  END IF  End
Sub

View 8 Replies View Related

Dynamiclly Setting Excel Connection String Issue

Nov 9, 2007


I have a folder of excel files with different file names and sheet names inside the file. So File A could have Sheet1A and file B could have Sheet2B.
The assumption is that the sheets would have similar data in them for all files even though sheet names are different. I was able to dynamically create the excel connection string using a for loop and choosing the Data Access mode of the excel source to be Table name or View name variable. I have run into a "[DTS.Pipeline] Error: "component "Excel Source" (1)" failed validation and returned validation status "VS_NEEDSNEWMETADATA".

Was wondering if anybody was able to play in such a scenario and resolve the issue.

By the way a lot of the posts in this blog helped me get this far so thanks for all the posts.

View 3 Replies View Related

SQL Server Failover:

Jan 22, 2007

 
I have to figure out a way to handle a failover in SQL Server 2005. I was reading a few articles about it.
1. Do I need to do anything in application layer to let a failover occur in SQL Server 2005
2. I have a web site that connects to a production server, the connection string is defined in web.config. If I implement Mirroring in SQL Server 2005, and when failover occurs, shouldn’t I change the connection string to point the application to the new server?

View 2 Replies View Related

Cluster Failover ?

Oct 2, 2007

Hi I just set up a new cluster and everything was working. Now when I try to test failovers like unplug the public network card etc...

The cluster group fails over correctly but my data and log array's dont failover.

So I unplug the network cable from node 1 (active) the cluster group with the IP, name, and Quorum disk fails over to node 2 but the other groups sql data and sql log stay on node1 and dont failover.

Any ideas?

TIA

View 14 Replies View Related

Failover Configuration

May 13, 2004

I have 4 servers, the first two are web app and load balanced the second two are to be configured for failover. Let us call them SvrA and SvrB. SvrA will have active SQL (2000EE) and passive Content (large directory of courses offered) SvrB will have passive SQL(2000EE) and active Content. Both SvrA and SvrB will be connected to a redundant SCSI 18 drive Drive bay (cheap SAN) which will be configured with a) mirrored OS drives, b) a RAID 5 partition for SQL and c) a RAID 5 partition for the content folders.

SvrA & SvrB will be quad processor machines. EE license for 4 processors as 2nd svr is failover for SQL.

My concern is the failover set up for the content portion, or is it the failure of the server that causes the failover? This is quite confusing to me.

Any thoughts would be most helpful.

View 2 Replies View Related

Automatic Failover

May 25, 2008

Hi there,
I am testing the db mirroring, making sure it will auto failover. I've stopped the SQL services on my principal and then I looked at the mirror db is says it's restoring. It stayed like that for 10 min before I enabled the mirroring again. Anyone knows why it's not failing over??????


Here's my setup: SQL 2005 Standard, Server 1 Principal, Server 2 Mirror & Witness.

View 4 Replies View Related

Cluster Failover

Mar 9, 2007

Hi all:

I was wondering what will happend to the transaction when the cluster failover from one node to another?

In my case the database is in node-001 and I need to restart the server on node-001. So I need to have the database failover to node-002, so I can work on node-001. During this process, will it effect to end-user?

Thanks
vua

View 5 Replies View Related

Log Shipping Failover

May 25, 2006

Is it possible to failover a single or a selected number of databasesonto a standby server? We're currently log shipping about 12 databasesto a standby and I was wondering if it was possible to randomlyfailover onto selected dbs.My understanding of log shipping is that when the primary server goesdown, the standby takes over. But, does that mean that all of the db'son the standby server now become the primary? Or, can failover occur onselected dbs?The reason I ask is because if one db on the primary, for example, wasto go down, I'd like to be able to bring the particular db on thestandby server online while I fix or restore what's on the primaryserver. Can it be done individually or is it an all or nothingscenario?Your personal advice or links is greatly appreciated.Thanks,Peps

View 1 Replies View Related

MS SQL Clustering And Failover

Jul 20, 2005

I have a 2 node Microsoft 2000 cluster with a shared storage device. Iwant to create automatic failover for MS SQL 2000 server. I can dothat wit the following options:1. Active/Pasive (one instance installed)2. Active/Active (More then one instance/virtual sql serversinstalled)I have a question about option 2.Is it possible to have more then one instance/virtual SQL server,service only one database for example loadbalancing. ?, or when youcreate multiple instances/virtual SQL servers, does that mean you havemultiple databases ? If not why does a Virtual SQL server has to betaken over by a cluster node that didnt fail. Then you can actuallyuse option 1. Please advise!The documentation is not very clear on this issues.Regards,Nico de Groot

View 1 Replies View Related

Recovery :: Not Able To Failover AG

Oct 15, 2015

Could not able to connect secondary replica below is the error message I am getting when I tried to failover. Cannot connect to VLDBATEAM.

The secondary replica that you selected to become the new primary replica does not belong to the specified availability group. A possible explanation is that the replica has not been joined the availability group.  (Microsoft.SqlServer.Management.HadrTasks)

View 6 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved