Log shipping role change

[barbara]

The pimary server has crashed. I couldn't able to run
sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
secondary server which is giving errors. sqlmain.exe failed. Any
ideas?

[Simon Hayes]

Re: Log shipping role change

barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=blue]
> The pimary server has crashed. I couldn't able to run
> sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> secondary server which is giving errors. sqlmain.exe failed. Any
> ideas?[/color]

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]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null




sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[barbara]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null




sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[barbara]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null







sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[barbara]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null




sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[barbara]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null



sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[barbara]

Re: Log shipping role change

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_cha nge_secondary_r ole
@db_name = 'test',
@do_load = 1,
@force_load = 1,
@final_state = 1,
@access_level = 1,
@terminate = 1,
@keep_replicati on = 0,
@stopat = null




sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=blue]
> barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=green]
> > The pimary server has crashed. I couldn't able to run
> > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > secondary server which is giving errors. sqlmain.exe failed. Any
> > ideas?[/color]
>
> 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[/color]

[Simon Hayes]

Re: Log shipping role change

barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408181322.363c ffdf@posting.go ogle.com>...[color=blue]
> 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_cha nge_secondary_r ole
> @db_name = 'test',
> @do_load = 1,
> @force_load = 1,
> @final_state = 1,
> @access_level = 1,
> @terminate = 1,
> @keep_replicati on = 0,
> @stopat = null
>
>
>
>
> sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=green]
> > barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=darkred]
> > > The pimary server has crashed. I couldn't able to run
> > > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > > secondary server which is giving errors. sqlmain.exe failed. Any
> > > ideas?[/color]
> >
> > 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[/color][/color]

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.aspx?scid=kb;en-us;294397

Simon

[barbara]

Re: Log shipping role change

Sorry for multilpe postings. I've opened another thread and closing this.

barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408181322.363c ffdf@posting.go ogle.com>...[color=blue]
> 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_cha nge_secondary_r ole
> @db_name = 'test',
> @do_load = 1,
> @force_load = 1,
> @final_state = 1,
> @access_level = 1,
> @terminate = 1,
> @keep_replicati on = 0,
> @stopat = null
>
>
>
>
> sql@hayes.ch (Simon Hayes) wrote in message news:<60cd0137. 0408180001.7513 9651@posting.go ogle.com>...[color=green]
> > barbara_2003@ho tmail.com (barbara) wrote in message news:<5cd01256. 0408171352.65a1 a20f@posting.go ogle.com>...[color=darkred]
> > > The pimary server has crashed. I couldn't able to run
> > > sp_change_prima ry_role procedure. I ran sp_change_secon dary_role in
> > > secondary server which is giving errors. sqlmain.exe failed. Any
> > > ideas?[/color]
> >
> > 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[/color][/color]