Viewing 15 posts - 2,596 through 2,610 (of 9,244 total)
jayoub (12/12/2014)
I get the following error when i try to add a database or make a backup or attach...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 9:43 am
Can you post the results of the following, replace "yourdb" with the name of the principal database names that have the issue
SELECTDB_NAME(database_id)
, mirroring_safety_level_desc
, mirroring_witness_state_desc
FROM [sys].[database_mirroring]
WHERE database_id IN (DB_ID('yourdb'),DB_ID('yourdb'),DB_ID('yourdb'))
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 9:24 am
snomadj (12/15/2014)
Thanks. I don't fully understand what restarting the end points does. Could it affect any of my other correctly mirroring live DBS?
So you have multiple Principal servers?
Are all the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 5:59 am
Manual or automatic failover are not available for asynch mirror sessions, do you have any?
Where asynch is in force you'll need to set Safety on, run from the principal
ALTER DATABASE...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 5:55 am
are the sql server services running??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 5:45 am
suedunham2 (12/15/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 5:41 am
Have you checked the state of the mirror endpoints? As a matter of course I would restart them.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 15, 2014 at 5:09 am
yes, unfortunately TDE negates backup compression.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 12:14 pm
Shahzadi (11/26/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 11:49 am
what did you do in the end?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 5:59 am
it shouldn't be a problem where the instances are already installed, ideally you would want to setup your cluster and soak test before you start deploying applications (clustered or non...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 5:57 am
you don't have to set a gateway on your NIC if you don't want to, but you won't have any ability to go outside your own network.
During cluster creation the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 5:56 am
so, if i'm reading corect now you're not deploying a failover cluster instance of sql server you're deploying standalone instances and intend to use AlwaysOn availability groups, is that correct?
Can...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 4:40 am
This is not performed exclusively on its own, it's part of a serious of steps and includes setting the underlying RAID stripe size and partition offset.
What work have you done...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 12, 2014 at 2:54 am
cdye (12/11/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
December 11, 2014 at 12:46 pm
Viewing 15 posts - 2,596 through 2,610 (of 9,244 total)