Viewing 15 posts - 3,451 through 3,465 (of 9,244 total)
smtzac (3/15/2014)
Yes. Recovering the Database. I don't think you can switch Principle server to Mirror if Principle is down, can you?
Yes of course you can, but it's a manual failover...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 15, 2014 at 10:06 am
New Born DBA (3/14/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 10:15 am
what do you see if you query the active processes, anything apparent there
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
March 14, 2014 at 10:13 am
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
Viewing 15 posts - 3,451 through 3,465 (of 9,244 total)