Viewing 15 posts - 2,836 through 2,850 (of 9,244 total)
before you even consider alwayson groups do you actually have the appropriate windows server and sql server licences?
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 11:37 am
another newbie (10/23/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 9:45 am
i'd love to help more but it's not entriely clear what your issue is
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 9:38 am
what command did you use to backup and restore the cert?
smtzac (10/23/2014)
CREATE ENDPOINT <endpoint_mirroring>
STATE = STARTED
...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 9:34 am
smtzac (10/22/2014)
I need to configure mirroring on a TDE database. I found out since it's TDE (encrypted db) can't use Wizard to configure mirroring.
You can still use the wizard if...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 5:15 am
jamessdba (10/23/2014)
Hi,My Logshipping is showing out of sync (sqlserver 2008R2)
Please provided the steps to analysis & how to fix it
Have you run a full backup on the primary since LS...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 5:11 am
Duran (10/22/2014)
Thanks for getting back. I'll see if I can try that.
Perry, my error is as follows
Cannot open backup device G:\SQLBackup\dbname.bak. Operating System error2(failed to retrieve text for this...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 4:49 am
fantom (10/22/2014)
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 4:30 am
shindle 17293 (10/22/2014)
Point taken re: first comment.
Once you understand the first comment the rest gets easy 😉
To re cap, An AlwaysOn Availability group across 2 Failover Cluster Instances of SQL...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 23, 2014 at 4:20 am
How many nodes in the cluster?
Who installed the current instance?
Add node is only used once you have run the New failover cluster instance wizard.
Each new clustered instance needs its own...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 1:28 pm
what errors do you see in the error log?
What detail does the wizard dispaly, click the error hyperlink for more detail
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 7:05 am
pawana.paul (10/20/2014)
I want to have 2 node cluster. Node 1 will have instanceA, Database ABC, Node 2 will have instanceB, Database ABC. Can I...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 5:36 am
Biank (10/21/2014)
I'm wondering if I can take native SQL log backup in addition to DPM backups. We're using DPM for both databases (daily) and logs (every 15min). So,...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 5:05 am
shindle 17293 (10/22/2014)
We are looking to setup an AlwaysOn A/G between two SQL instances across two SQL clusters - one cluster has two nodes the other has three nodes.
Firstly, it's...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 4:58 am
SQLAssAS (10/22/2014)
approach 1:
Prod - shared storage between server 1 and 2
Server1: clustered SQL instance with availability group as primary
Server2: Passive server for clustered instance...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 4:48 am
Viewing 15 posts - 2,836 through 2,850 (of 9,244 total)