Viewing 15 posts - 2,446 through 2,460 (of 9,241 total)
Perry Whittle (1/25/2015)
Level 5...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:59 am
sorry there's been so many posts here I'm lost in the myre now.
Do you want to deploy an FCI only?
If yes leave part 4 you don't need it
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:59 am
Calvin Duffy (1/29/2015)
No full backup was taken after the mirroring broke.
If a full backup has occurred on the principal since mirroring broke you're stuck with re initialising mirroring unless...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:55 am
Ozzmodiar (1/29/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:51 am
select SizeBytes, SizeBytes / 1024 As Megabytes
from
TESTTABLE
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:17 am
you don't have an FCI to integrate so skip that, the portion that shows how to create an AO group will be relevant though
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:15 am
So, has a full backup been taken on the principal since the mirroring broke?
Use this query against the principal and then the mirror to ascertain if it has or not
select...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:13 am
an Availability group can only have one primary read\write database, The remainder are readable secondaries!
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 11:06 am
ncodd (1/29/2015)
I need a simple script that will convert this field to MB & round up.
Convert it to what?
just divide it by 1024 will give whole MBs. Are...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 9:54 am
we have one here over 8TB in size and growing
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 9:50 am
Calvin Duffy (1/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 9:48 am
so for a given AO group and database, all 6 instances will be replicas in that group?
Which server have you reserved as your primary replica?
Why sooo many listeners?
Which site is...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 9:28 am
keep an eye on the size of the version store too
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 7:33 am
GilaMonster (1/29/2015)
In simple recovery a checkpoint truncates the log.
And even then there are drivers behind this, it won't necessarily truncate on every checkpoint
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 7:19 am
muthukkumaran Kaliyamoorthy (1/29/2015)
Perry Whittle (1/29/2015)
muthukkumaran Kaliyamoorthy (1/28/2015)
Since it's already a GEO cluster 4 node in USA (6 SQL instances)+ 2 node in China (2 SQL instances).
All 6 nodes part of...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 29, 2015 at 6:03 am
Viewing 15 posts - 2,446 through 2,460 (of 9,241 total)