Viewing 15 posts - 1 through 15 (of 24 total)
Yea Sir. DNS server is accessible from Node where Failover cluster is installed.
August 10, 2015 at 7:54 am
Yes sir i have used iSCSI storage devices. I have separate SAN windows. During cluster validation, there is no single warning related to SAN storage drives. I will generate cluster...
July 26, 2015 at 11:15 am
I have attached the snapshot of Ip configuration of Node1 , Node2 and DC.
Node1 and Node2 has both private and Public ip.
Now i have recreated cluster and reinstalled Active...
July 24, 2015 at 7:36 am
Yes Sir, I have already installed Windows Failover cluster. I have 2 Nodes windows failover cluster. I am going to install Sql server active active failover cluster using 2 node....
July 22, 2015 at 5:26 am
Thanks Sir for your kind information.
July 21, 2015 at 6:23 am
Could you please let me know how do i find which tables stats needs to be updated instead of whole table's stats.
So that i do not have to...
July 14, 2015 at 10:42 am
Thanks Sir for reply.
We have transaction replication to 2 other instance's databases. if something happens and main database server there will be loss of 1-2 second's records only.
July 10, 2015 at 12:15 am
Thanks for reply and suggestion Sir. As per our business requirement, we need to take only one time FULL database back up and transnational log backup . Could you please...
July 9, 2015 at 3:37 am
Could you please tell me why same query is performing slow in peak transaction hour. However same query performs faster in staging of same database size as well as less...
July 7, 2015 at 6:05 am
Thanks Sir, Answer given by you for question 1 and question 2 is sufficient answer for me.
June 26, 2015 at 7:24 pm
Thanks Sir. That really helped.
June 25, 2015 at 11:51 pm
By using operator, we can configure sending mail either in fail only or success only. is any possible to configure email using operator sending email not only in failure of...
June 22, 2015 at 9:02 am
Dear Sir thanks for reply.
one of the table referencing to primary key table has FK WITH NOCHECK. However another table which has FK reference to primary key table, have...
June 22, 2015 at 8:06 am
Database is in full recovery mode. Back up is scheduled at night time 12 AM for both FULL DB backup and log file(that time almost no transaction in our database).
June 13, 2015 at 8:26 pm
We have real time replication.
we have 3 databases like below
Database A: for Read and Write
Database B: for Read only
Database C: for Disaster Recovery Purpose
Real time replication is done...
June 10, 2015 at 10:36 pm