Viewing 15 posts - 2,461 through 2,475 (of 9,253 total)
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...
January 29, 2015 at 9:28 am
keep an eye on the size of the version store too
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
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...
January 29, 2015 at 6:03 am
Hadrian (1/29/2015)
There is no backup of certificates or keys from Server A. And no one knows the password used to create those backups.
Having trouble understanding this, do you or do...
January 29, 2015 at 5:56 am
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 the same WSFC?
muthukkumaran Kaliyamoorthy...
January 29, 2015 at 4:35 am
3 please
Backup all user databases first and export any logins, jobs, linked servers, certs, etc.
Clean OS and install new version of database engine, you'll be able to use the same...
January 28, 2015 at 3:49 pm
check your sql server version, may need this fix before removing TDE
January 28, 2015 at 3:42 pm
Ozzmodiar (1/28/2015)
January 28, 2015 at 3:37 pm
ok, but do you really need to have 3 nodes in the remote site too?
Surely a failover to the remote site will only ever be for a short period of...
January 28, 2015 at 2:29 pm
it's not mentioned the nodes are on separate physical sites so option 1 is very straight forward, its just extending the cluster and the AO group.
Option 2 however does have...
January 28, 2015 at 2:21 pm
yes, you can use both but there are restrictions so don't do it lightly.
Keeping the instances standalone will provide you a flexible configuration with no shared storage requirements, very handy...
January 28, 2015 at 2:14 pm
Do you plan to include any Failover Cluster instances of sql server in your AlwaysOn group configuration?
January 28, 2015 at 2:04 pm
muthukkumaran Kaliyamoorthy (1/28/2015)
Yes, Correct. Server A & B old - SQL 2012. And need to move it to server C & D new - SQL2014.
So, you have two options
The first...
January 28, 2015 at 11:17 am
can you connect to the instance and run
select @@version
January 28, 2015 at 10:56 am
Viewing 15 posts - 2,461 through 2,475 (of 9,253 total)