Viewing 15 posts - 2,836 through 2,850 (of 9,241 total)
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
more importantly, as well as adding the listener you must correctly configure the read only routing within the AlwaysOn group to offload the read only intent connections to an AlwaysOn...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 4:38 am
ramana3327 (10/20/2014)
I am looking for some best practices of migrating 2008r2 to 2014 and implementing always on.
a simple google search would produce the results you require. VMWare have an...
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 22, 2014 at 4:36 am
shahgols (10/20/2014)
TheSQLGuru, you are the man, that is the correct answer! tHANK YOU!
Have you even bothered to read my replies??
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
October 20, 2014 at 7:19 pm
Viewing 15 posts - 2,836 through 2,850 (of 9,241 total)