473,320 Members | 1,961 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

Log shipping role change

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?
Jul 20 '05 #1
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
Jul 20 '05 #2
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

Jul 20 '05 #3
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

Jul 20 '05 #4
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

Jul 20 '05 #5
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

Jul 20 '05 #6
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

Jul 20 '05 #7
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

Jul 20 '05 #8
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
Jul 20 '05 #9
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

Jul 20 '05 #10

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

Similar topics

1
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...
0
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();...
2
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...
2
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...
2
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...
0
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...
0
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...
4
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...
2
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...
0
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...
0
isladogs
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...
1
isladogs
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...
0
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...
1
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)...
0
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...
0
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....
0
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
0
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...

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.