Viewing 15 posts - 136 through 150 (of 195 total)
If the link problem is resolved the database will came back online...synchronized.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
October 20, 2011 at 1:36 am
Always remember no changes to the database properties in a mirroring session.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
October 20, 2011 at 1:26 am
You have to do a manual fail-over
On the mirror
ALTER DATABASE <database name> SET PARTNER OFF
RESTORE DATABASE <database name> WITH RECOVERY
when the principal is back online you have to re-establish...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
October 20, 2011 at 1:21 am
Just on spot...but it failed on dabase with spaces in between like [my fun database]
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 29, 2011 at 7:13 am
I did know that transactional replication depends on the state of the mirror.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 21, 2011 at 12:15 am
My answer was correct, think this is another typo,but i would think T-SQL are quite easy to verify.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 15, 2011 at 4:03 am
Size of log is 5 745 664 KB.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 5:49 am
I got valuable information about mirroring metrics from the sites thank you so much.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 5:29 am
Thank you for the link it was so valuable.
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 5:28 am
Are you saying is the principal has been changed to mirror,it will be still accessible?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 5:19 am
So you mean on top of the daily back-ups i am taking, i need to take Daily transaction logs as well?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 5:01 am
You raised another issue of ports.On two separate physical servers you need to specify the same port number.On the same server you different port numbers.This is what i have once...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 4:58 am
If the principals lose connection that is the state of the cause.If the connection is established the databases will revert to their normal states.Causes of that could be:
1.DNS server is...
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 3:53 am
@crazy4sql,dont get you.Follow this link for a tutorial http://msdn.microsoft.com/en-us/library/ms170246%28v=sql.90%29.aspx
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 13, 2011 at 1:51 am
Can i fail-over databases because of power failure?
“When I hear somebody sigh, ‘Life is hard,’ I am always tempted to ask, ‘Compared to what?’” - Sydney Harris
September 12, 2011 at 2:54 am
Viewing 15 posts - 136 through 150 (of 195 total)