March 9, 2016 at 2:22 am
I have mirroring configured in synchronous mode with out witness server , suddenly my principle went down how can we made the database with out data loss?
March 9, 2016 at 2:53 am
also what about the transactions if the principle is down ?
March 9, 2016 at 3:18 am
Hi,
google is your friend, sorry, but the first hit was the best answer:
If the principal server is lost, the mirror is suspended, but service can be forced to the mirror server (with possible data loss).
https://technet.microsoft.com/en-us/library/ms179344%28v=sql.105%29.aspx?f=255&MSPPError=-2147217396
Watch the text at "High-Safety Mode Without Automatic Failover"
Kind regards,
Andreas
March 10, 2016 at 10:31 am
USE master
ALTER DATABASE [database] SET PARTNER FAILOVER;
GO
March 10, 2016 at 10:44 am
Jon.Morisi (3/10/2016)
USE master
ALTER DATABASE [database] SET PARTNER FAILOVER;
GO
You cannot failover normally as the principal is lost\offline, with a synch session no witness and failed principal you have to use
USE master
ALTER DATABASE [database] SET PARTNER FORCE_SERVICE_ALLOW_DATA_LOSS;
GO
[/
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
Viewing 5 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply