sp_change_primary_role procedure. I ran sp_change_secondary_role in
secondary server which is giving errors. sqlmain.exe failed. Any
ideas?barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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|||barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408181322.363cffdf@.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
>
>
> sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> > barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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/defaul...kb;en-us;294397
Simon|||Sorry for multilpe postings. I've opened another thread and closing this.
barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408181322.363cffdf@.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
>
>
> sql@.hayes.ch (Simon Hayes) wrote in message news:<60cd0137.0408180001.75139651@.posting.google.com>...
> > barbara_2003@.hotmail.com (barbara) wrote in message news:<5cd01256.0408171352.65a1a20f@.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
No comments:
Post a Comment