Viewing 15 posts - 2,476 through 2,490 (of 9,244 total)
muthukkumaran Kaliyamoorthy (1/28/2015)
Yes, I have AG group in SQL 2012 which has two replicas primary and secondary.
So if i have it correct, you have the following
ServerA and ServerB with a...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 10:27 am
are you using availability groups?
if you're not then disregard my previous post and i'll explain it differently to match your scenario
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 10:13 am
SQLKnowItAll (1/28/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 9:52 am
Simple, setup a new replica whioch is SQL Server 2014 and introduce it into your AlwaysOn group. Add the secondary database and let it synchronise.
Once synchronised you may then fail...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 7:43 am
what does the dashboard show?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 7:40 am
remove any secondary databases from the availability group by;
connected to the primary using the GUI and selecting the required database under "Availability databases". Then under the AO group, right click...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 4:21 am
S. Kusen (1/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 3:33 am
SQLKnowItAll (1/26/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 3:29 am
S. Kusen (1/27/2015)
The storage for each FCI would be presented to each node of the cluster.
No, see above. To recap, you'll only usually unmask the shared storage to nodes where...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 28, 2015 at 3:27 am
Calvin Duffy (1/27/2015)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 10:46 am
i wouldnt rely on the training course to be able to help you resolve this, you may be disappointed.
Can you provide more detail from the package error log
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 9:19 am
ramana3327 (1/26/2015)
2008r2 enterprise edition
run the following against one of the backup files and check the value returned in the compressed column
restore headeronly from disk = 'drive:\path\path\backupfilename.bak'
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 9:13 am
Dam_DBA (1/27/2015)
here is the situation : I have a primary instance, who host three databases, and (this is the trick) one got encrypted column by symmetric key (the...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 9:08 am
what are the synch modes set on the replicas?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 8:20 am
do you intend to remove the primary and all secondarys?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 27, 2015 at 8:17 am
Viewing 15 posts - 2,476 through 2,490 (of 9,244 total)