February 11, 2009 at 2:47 pm
I have mirroring configured in my environment
When i click on server-1 which is principle
I can see my database status as-- (Principle,synchronized)
when I go to server-2 which is mirror
I can see my database status as --(Restoring)
I can see this for all 4 databases and sizes of these databases are
1.4 GB,10 GB,23 GB, 900 MB
When I wrote this query on principle and mirror
Select * from sys.database_mirroring where mirroring_state is not null
i can see all databases are connected and synchronized
and everything looks fine
My question is why i can see database status = Restoring on server-2 instead of mirror,synchronized??
February 11, 2009 at 6:51 pm
What do you see under database mirroring monitor?
MJ
February 12, 2009 at 8:38 am
The "Restoring..." on the mirror is the default state. Remember when you set it up, you restored the database and left it in that state so the log transactions can be updated via the mirroring service.
February 12, 2009 at 8:49 am
I observed these in mirroring monitor after few minutes
under db monitoring i can see principle = connected and mirror = not connected
some times it shows connected as well
n we have one witness server to keep an eye... we dont get any errror nor failover occurs..
is this because of transaction log backups? we have eevry 30 mins trn backup and
probably it takes longer to ship tht trn backup file on another server...which puts
the database in restoring mode?
February 12, 2009 at 9:18 am
February 12, 2009 at 2:27 pm
yes sometimes its in 'restoring' mode
and sometimes it says mirrored,synchronized,restoring
but my principle is always up and running so we dont know
weather its any warning or is it bad if failover will occur?
February 12, 2009 at 2:46 pm
Secondary status should be something like this..
Mirror,Synchronized/Restoring
Mirror,Synchronizing/Restoring
If the status is not in above two and just it is restoring, then its a broken case. you will have to re-create mirroring.
Thanks,
Sudhie.
February 12, 2009 at 2:48 pm
hmmm... as i told u... i can see the status sometimes as
(Mirror,Synchronized/Restoring...)
so looks like it fixes by itself only..... strange...
February 12, 2009 at 2:59 pm
dallas13 (2/12/2009)
hmmm... as i told u... i can see the status sometimes as(Mirror,Synchronized/Restoring...)
so looks like it fixes by itself only..... strange...
no its not strane its the default behavious of a Mirrored Database articipating it DB Mirroring. You have to really go through the concept.
check this out:
February 12, 2009 at 3:09 pm
Krishna (2/12/2009)
dallas13 (2/12/2009)
hmmm... as i told u... i can see the status sometimes as(Mirror,Synchronized/Restoring...)
so looks like it fixes by itself only..... strange...
no its not strane its the default behavious of a Mirrored Database articipating it DB Mirroring. You have to really go through the concept.
check this out:
i agree...i still wonder, how come secondary is going to restoring state and primary in connected state..
will connection failures for some time take secondary to restoring state and then successful connection after some time is taking it to synchronized state? I mean is there any possibility, i never experienced such weird behaviour.
February 13, 2009 at 12:04 pm
yes thats what i m assuming that connection issues might cause these things to arise..
but still looking for some perfect answer
February 13, 2009 at 12:09 pm
From what I have been reading, you don't have a problem. The mirroring is working just as it is supposed to work. Stop worrying until you have something to worry about.
February 13, 2009 at 12:20 pm
IMO your connection between primary and mirror isn't stable.
Hence the restoring state from time to time.
If it can form a quorum it will pull over the log entries of the principal db and get to "mirrored, synchronised, restoring" state.
If you need to fail over to your mirrored db, at a time that the connection has been lost for a while, you can only make that db principle by forcing it ... so you will not have the most recent data !
If that isn't allowable, you need to set up an alert system to inform you connection has been lost !
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
February 18, 2009 at 1:19 pm
yes
i have a witness server to keep an eye on my principle and mirror
and principle is forming a quoram
thats why when i perform select * from sys.database_mirroring
on principle or mirror i can see the status =connected.
I have only one issue--i can see the status of mirror server's database ='Restoring'
instead of 'Mirrored,synchronized,Restoring'
So i m aslo assuiming it might be connection lost then how can i make sure
that its definately connection lost? how to configure those alerts?
February 19, 2009 at 1:23 am
Check "Monitoring Mirroring Status " in Books online to start with.
It explains there is a whole set of tools to serve you.
Johan
Learn to play, play to learn !
Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:
- How to post Performance Problems
- How to post data/code to get the best help[/url]
- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 15 posts - 1 through 14 (of 14 total)
You must be logged in to reply to this topic. Login to reply