The pimary server has crashed. I couldn't able to run
sp_change_primary_role procedure. I ran sp_change_secondary_role in
secondary server which is giving errors. sqlmain.exe failed. Any
ideas? 9 3125 ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and
"failed" mean? You will need to post more information for someone to
be able to make a suggestion - what version of MSSQL, how are you
running sqlmaint.exe, what exact commands did you execute and what are
the complete error messages?
Simon
Becuase primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
Becuase primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
Because the primary server is unavailable, I couldn't able to demote
the primary server. I ran the following sql to promote secondary to
primary.
But it fails always. I've tried with @terminate=0. No user connections
exist in database. I would apprecite if anyone got this kind of
problem. I've seen KB article, but still getting error, sqlmaint.exe
failed
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
Becuase primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
Becuase primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
Becuase primary server is unavailable, I couldn't able to demote the
primary server. I ran this query to promote secondary server. I've
tried with different options @terminate=0. I've ensured no user
connections exist. But still getting sqlmint.exe error. Any one
experienced this problem? I've checked KB article, but still not
working
EXEC msdb.dbo.sp_change_secondary_role
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replication = 0,
@stopat = null sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... Becuase primary server is unavailable, I couldn't able to demote the primary server. I ran this query to promote secondary server. I've tried with different options @terminate=0. I've ensured no user connections exist. But still getting sqlmint.exe error. Any one experienced this problem? I've checked KB article, but still not working
EXEC msdb.dbo.sp_change_secondary_role @db_name = 'test', @do_load = 1, @force_load = 1, @final_state = 1, @access_level = 1, @terminate = 1, @keep_replication = 0, @stopat = null
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon
As I mentioned in my previous post, no one can help you if you don't
provide more information. Saying that you get an error is not very
helpful - you always need to say exactly what the full error message
is. You can simply copy and paste it from Query Analyzer.
And if you have searched the KB, it helps to say which articles you
have already checked. For example, is this one relevant? http://support.microsoft.com/default...b;en-us;294397
Simon
Sorry for multilpe postings. I've opened another thread and closing this. ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... Becuase primary server is unavailable, I couldn't able to demote the primary server. I ran this query to promote secondary server. I've tried with different options @terminate=0. I've ensured no user connections exist. But still getting sqlmint.exe error. Any one experienced this problem? I've checked KB article, but still not working
EXEC msdb.dbo.sp_change_secondary_role @db_name = 'test', @do_load = 1, @force_load = 1, @final_state = 1, @access_level = 1, @terminate = 1, @keep_replication = 0, @stopat = null
sq*@hayes.ch (Simon Hayes) wrote in message news:<60**************************@posting.google. com>... ba**********@hotmail.com (barbara) wrote in message news:<5c**************************@posting.google. com>... The pimary server has crashed. I couldn't able to run sp_change_primary_role procedure. I ran sp_change_secondary_role in secondary server which is giving errors. sqlmain.exe failed. Any ideas?
I have no idea - what do "I couldn't run", "giving errors" and "failed" mean? You will need to post more information for someone to be able to make a suggestion - what version of MSSQL, how are you running sqlmaint.exe, what exact commands did you execute and what are the complete error messages?
Simon This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Jennie |
last post by:
I am implementing Log Shipping. I have the transaction logs copying to
the standby server and applying to the standby database with no errors.
However, I am having problems with the role...
|
by: maersa |
last post by:
Hi all,
i'm serializing an arraylist like the following with an "Role" object as
it's item.
-----------------------------------------------------
----
ArrayList ar = new ArrayList();...
|
by: nek |
last post by:
Greetings,
I tried to implement log shipping using PULL method as described in
'The Basics of DB2 Log Shipping' by Dale McInnis, but found the
subsequent "rollforward" did not go beyond the...
|
by: Fred |
last post by:
Hi.
Sorry, but I don't know where else to ask. I wrote a access shipping
database and we currently use the web interface for DHL to print shipping
labels. That means we have to manualy transpose...
|
by: bradgatewood |
last post by:
I am in the process of developing a highly customizable application and
I'm looking for a way to allow personalization by role. This is
different than shared scope in the fact that I want to allow...
|
by: theSpinel |
last post by:
Is it possible to move the log shipping monitor to a different server
without having to re-create the log pairs? Hardware on our existing log
shipping monitor server is failing and we need to bring...
|
by: NiTiN |
last post by:
Hi!
I'd like to know if it is possible to change the monitor server when
using Transaction Log Shipping. I tried visiting the Transaction Log
Shipping page of Database Properties but the Monitor...
|
by: J MCallister |
last post by:
Hello, I am working on a shopping cart where the viewer sees a dropdown
with shipping options, each with a price.
Elsewhere on the page is a display of the total.
I am working on having the...
|
by: Anthony Smith |
last post by:
I have a user object that is set when a user logs in. There are also
permissions that I get about the user from a web service. Currently I
take the results from those web services and store them as...
|
by: DolphinDB |
last post by:
Tired of spending countless mintues downsampling your data? Look no further!
In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: isladogs |
last post by:
The next Access Europe meeting will be on Wednesday 6 Mar 2024 starting at 18:00 UK time (6PM UTC) and finishing at about 19:15 (7.15PM).
In this month's session, we are pleased to welcome back...
|
by: Vimpel783 |
last post by:
Hello!
Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
|
by: PapaRatzi |
last post by:
Hello,
I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
|
by: CloudSolutions |
last post by:
Introduction:
For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
|
by: Shællîpôpï 09 |
last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....
|
by: af34tf |
last post by:
Hi Guys, I have a domain whose name is BytesLimited.com, and I want to sell it. Does anyone know about platforms that allow me to list my domain in auction for free. Thank you
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
| |