The script contains scripted database objects(schema) and the data.

he finding was that there was an audit trail function that was enable and contributing to datbase growth.

I found the error I had two similar jobs doing the same thing and the maintenance plan that I was sending notification I was checking was actually failing.Noted and thank...

I think the maintenance plan should have created a SQL Server agent job. Can you have a look at the history of that job and see if it shows any...

As a follow-up question how do i ensure that the databases are identical when I failover from production to DR and then from DR to live without data loss and...

AGs in two different clusters can be connected into a Distributed Availability Group (https://docs.microsoft.com/en-us/sql/database-engine/availability-groups/windows/distributed-availability-groups?view=sql-server-2016), which will provide you with AG-to-AG (in your case, site-to-site) replication. When using...

1.Windows Cluster 2

What kind of cluster?----Windows failover cluster

2.Availability Group with four databases (2 syncronous and 2 asyncronous)

Where are the availability groups failing over to?---database level when the primary database health...

Did not know interesting to know.

I created the procedure as per advice above the only hassle is that when transactions where the procedure is called did not commit,or fail some.It will arise in some document...

Thanks for the question!!

R becoming easy for me...thanks Steve.

That was an easy one for me thanks.