Hi Samuel,

"quick cluster failover causes the majority of the connections to die so was thinking that we can drop the fci and just use ag's?" - Yes....

Hi ShawnShine,

To setup databaseNumber2 on DB2, Restore a full backup of databaseNumber2 on DB2. (you ought to do a full backup of the databases before you start your...

In addition, A differential backup is based on the most recent, previous full data backup. A differential backup captures only the data that has changed since that full backup. The full...

Hi 
This happened to us few months back. We rebooted the secondary replica server and it resolved the issue.

Best Regards,

Hi 

After you do a failover with allow data loss, the next step is to resume data movement to put the database (secondary replica) in SYNCHRONIZING state.

1....

Hi Sree,

You may also check out the link below on "Prereqs, Restrictions, Recommendations - Always On Availability Groups"

July 18, 2017 at 2:02 am

#1951313

Hi

You may also refer to this useful article entitled "A beginner’s guide to SQL Server transaction logs"  
https://www.sqlshack.com/beginners-guide-sql-server-transaction-logs/

Best Regards,

Hi

I noticed on your screenshot that mirroring endpoint of your primary repica is 445. It should be 5022.

1. Ensure the mirroring endpoints are created and started...

Hi Krishna,

Here are my suggestions:

1.       Setup the following performance counters:
          a.       avg disk sec/read (on...

Hi ifilter,

You have to perform the installation first before you create listener and Availability Groups.

You may refer to the link below for the step by step...

Here are some important security guidelines:

- Use Procedures and Views for object access
- Use DB Roles as containers for users
- Manage user permissions at the role...

Hi

Try to login to windows server as administrator. Then go to services.msc. Are you able to see all your services there? if Yes. Perfect

Now, install SQLEXPR_x64_ENU.exe.

Hi 

Please perform the following. Let’s see how we can pinpoint the cause of the slowness.

Firstly, let’s identify the hardware resources bottlenecks. SQL Server performance is affected by the stres...

Hi 

Please tick the box under "Automatic Failover" then see if the NEXT command button will be enabled. Furthermore, you will also have to decide if you want the...