Hi all,

I'm trying to stop a database server in my mirror system. I connect with Interactive SQL to primary server and execute

ALTER DATABASE SET PARTNER FAILOVER

I've an error message:

Request start/stop database denied.

I've set the -gk option to ALL.

asked 19 Apr '12, 05:49

snafuz88's gravatar image

snafuz88
46559
accept rate: 0%


You must connect to the database on the server that is acting has primary and have DBA authority on that database in order to force the failover.

Note that the setting of -gk only controls who is allowed to connect to the utility_db on the server. Since you mentioned this I am going to assume that you connected to the utility_db and not the database that you are trying to force a failover.

For reference, here is the documentation section on how to initiate failover.

permanent link

answered 19 Apr '12, 08:35

Mark%20Culp's gravatar image

Mark Culp
22.7k9129266
accept rate: 40%

Thanks you for your quickly answer.

I've solved this issue. Problem was this:

Incorrectly:

OPTIONS="-c500m -cl500m -dt/dev/shm -gkALL -gp4096 -n$SERVERNAME -o$LOG -oe$ERRORLOG -susptnkx -ud -x$PROTOCOL"

Correctly:

OPTIONS="-c 500m -cl 500m -dt /dev/shm -gk ALL -gp 4096 -n $SERVERNAME -o $LOG -oe $ERRORLOG -su sptnkx -ud -x $PROTOCOL"

I have seen that nothing happens. I expected that the DB went into read-only mode.

The last sentence of the documentation says that this operation is controlled by the -gk option, that's what I have to specify.

permanent link

answered 19 Apr '12, 10:02

snafuz88's gravatar image

snafuz88
46559
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here

By RSS:

Answers

Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:

×27

question asked: 19 Apr '12, 05:49

question was seen: 711 times

last updated: 19 Apr '12, 10:02