Viewing 15 posts - 2,476 through 2,490 (of 9,241 total)
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
RUNNERSQL (1/24/2015)
how do i transfer this login to mirror server and assign the same permission...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2015 at 10:53 am
which edition\version of sql server are you using?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2015 at 8:39 am
done this before a few times, i have used a new cluster with its own storage and mighrated databases between clusters.
Leaves a you a rollback scenario in place
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 26, 2015 at 8:02 am
Viewing 15 posts - 2,476 through 2,490 (of 9,241 total)