August 12, 2013 at 2:51 am
We have mirroring set up over a WAN and as such opted for manual failover to avoid network issues causing automatic failover and rendering connected clients unusable.
My question is, if the primary site was destroyed and connection to the principle is lost...is it still possible to failover or do you have to have that connection?
Many thanks
David
'Only he who wanders finds new paths'
August 12, 2013 at 2:56 am
Can I do this on the mirror?
ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
'Only he who wanders finds new paths'
August 12, 2013 at 3:48 am
Did you have a look at BOL ?
Forced Service (with Possible Data Loss) http://technet.microsoft.com/en-us/library/ms189977(v=sql.100).aspx
it has a ref How to: Force Service in a Database Mirroring Session (Transact-SQL). which states the command you mentioned for the purpose you intended.
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
August 12, 2013 at 4:08 am
Yes of course I looked on BOL, I was just after some confirmation really after posting the command. However, I didnt put any of that in my 2nd post and left it rather brief relying on everyones psychic knowledge which I apologise for! Thanks for the reply and yes, its exactly what I was looking for.
Thanks again. 🙂
'Only he who wanders finds new paths'
August 12, 2013 at 5:13 am
Of course, testing it is fairly easy to do and the preferable way before implementing it into production.
Walk through all scenarios and test the actions before you need to apply them in production.
I strongly advise to monitor your mirrored databases as mentioned in BOL:
and prepare your DRP inventory scripts 😎
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
August 13, 2013 at 12:07 pm
david.alcock (8/12/2013)
Can I do this on the mirror?ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Losing the principal in either async mode or sync mode with no witness requires you to use the above query to bring the mirror online.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 14, 2013 at 3:13 am
Hi
ALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High performance and High safty mode configured
USE master
GO
ALTER DATABASE <MIRROR DATABASE> SET PARTNER OFF
GO
RESTORE DATABASE <MIRROR DATABASE> WITH RECOVERY
GO
August 14, 2013 at 3:27 am
ananda.murugesan (8/14/2013)
HiALTER DATABASE<Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
Instead of above query, can we run as below query for make it online in MIRROR Database..? Mirror database always sychronizing/Restoring mode. wheather High performance and High safty mode configured
USE master
GO
ALTER DATABASE <MIRROR DATABASE> SET PARTNER OFF
GO
RESTORE DATABASE <MIRROR DATABASE> WITH RECOVERY
GO
That would turn it back into a non-mirrored database !
If you would want to re-enable mirroring for that database, you would have to perform the full setup for it.
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
August 14, 2013 at 3:37 am
I have doubt.. I have Mirror setup manual failover without witness server
If Principal server is down due to N/W or H/W issues, In this cause mirror database condition is Restoring only...so I want to make online mirror database which command need to be executed?
Is it correct as below command? only one command
ALTER DATABASE <MIRROR DATABASE> WITH RECOVERY
rgds
ananda
August 14, 2013 at 6:45 am
ananda.murugesan (8/14/2013)
I have doubt.. I have Mirror setup manual failover without witness serverIf Principal server is down due to N/W or H/W issues, In this cause mirror database condition is Restoring only...so I want to make online mirror database which command need to be executed?
Is it correct as below command? only one command
ALTER DATABASE <MIRROR DATABASE> WITH RECOVERY
rgds
ananda
As i said, whether you use synch or asynch mirroring without a witness, if you lose the principal the only way to bring the mirror online is by using
ALTER DATABASE <Databasename> SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
August 15, 2013 at 10:48 pm
Thank you for replay
As per BOL, forcing service facilitates resynchronizing the databases (with possible data loss) when mirroring resumes and make it mirror database online..
Is it possible how much data cab be loss? after executed that statement
If we are using High safty mode in mirroring session not possible for data loss, It was two way committed transaction on both servers. Pl. confirm
rgds
anand
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply