Viewing 15 posts - 4,666 through 4,680 (of 9,244 total)
What disk type are you using, what does Windows think the type is?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 11:50 pm
consecutive pageids, you may want to run a storage health check too.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:52 pm
jvkondapalli (11/5/2012)
We have APP1, APP2. When I create Windows Server Failover Cluster(WSFC) with 3 nodesnode 1 - Primary Replica - APP1 is connected with cluster name
The WSFC name is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:40 pm
OK, just tested it myself. If your mirror instances all run as the same service account leaving the boxes blank is fine, you won't see any GRANTs as the service...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 1:21 pm
scogeb (11/5/2012)
That returns the user that was used to connect to the pincipal, mirror and witness when mirroring was set up using the wizard.
Yes, that's what I'm expecting 😉
Are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 8:22 am
CuriousDBA (11/4/2012)
I have created maintenance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 5, 2012 at 6:37 am
yes, from SQL Server 2012 mirroring is superseded by AlwaysOn
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 11:31 am
deebabat (11/4/2012)
I don't really know what information you want me to provide
This will do for starters
Whay...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 9:51 am
Perry Whittle (11/4/2012)
Can you supply more detail about your mirror setup?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 6:33 am
Can you supply more detail about your mirror setup?
Can you post details of this query run against the principal
Select name, user_access_desc, state_desc,
recovery_model_desc
from sys.databases
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 4:53 am
Mac1986 (11/4/2012)
Then can I drop and recreate the DB with My choice of data files?
Are you referring to the source database??
Mac1986 (11/4/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:56 am
What is the failure message in the sql server error log?
Have a read through this
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:46 am
Books online should tell you all you need. Have you had a look on google. I seem to remember there was a whitepaper from Microsoft on the HA technologies.
Once you...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 4, 2012 at 2:34 am
scogeb (11/2/2012)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 2:25 pm
The mirroring wizard states
Database Mirroring Wizard
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
November 2, 2012 at 1:26 pm
Viewing 15 posts - 4,666 through 4,680 (of 9,244 total)