Viewing 15 posts - 3,451 through 3,465 (of 9,241 total)
singh.kamaldeep (3/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 2:56 am
smtzac (3/13/2014)
when principle server goes down (server level), in an asynchronous DB mirroring, what is the best option and/or steps for production environment?
best option for what, are you referring to...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 2:51 am
nikhil.desai1 (3/11/2014)
There are 2 server A (principal) and B(Mirror) -Synchronous Mode without automatic fail-over. When principal A goes down Mirror B database is brought up using command
ALTER DATABSE SET PARTNER...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 2:48 am
zedtec (3/13/2014)
I just wanted to know what would happen in the scenario where you've got database mirroring configured over a WAN and one site goes down and loses connection with...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 4:05 pm
smtzac (3/13/2014)
I am configuring DB mirroring on principle database and the database has Full,Diff,TranLog backups job running everyday on Sql Agent.
In order to configure Mirroring on principle database...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 3:55 pm
Just to clear any confusion, you may have more than 2 synch replicas. However, only 2 synch replicas may be configured for auto failover at any one time, any attempt...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 10:51 am
Lempster (2/18/2014)
As soon as the new Mirror (former Principal) is back online, the mirroring session will resume and the Mirror will be in a Synchronizing state.
The mirror session will be...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 10:24 am
Database mirroring will be removed in a future version, for this reason it would make sense not to use an exiting technology, but use the option that has effectively replaced...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 9:23 am
yes
If you try and run the installer on a Windows 2012 server it should fail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:24 am
is this a virtual machine, which hypervisor platform are using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:18 am
maida_rh (3/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:12 am
ok, that means that it will accept read\write and read intent connections
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:02 am
you're welcome 😎
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:01 am
william.rees.howells (3/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 8:00 am
Adam Bean (3/13/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 13, 2014 at 7:57 am
Viewing 15 posts - 3,451 through 3,465 (of 9,241 total)