Hi Darryl,

Run it on the "distribution" database. Please re-execute the script below. I've indicated the database name,

--run in the distribution database

Hi Nadersam,

You also have to check the Windows Server Failover cluster. Is your Cluster core group resources online or offline?
If it is offline, you have to bring...

Hi 

you may find this link helpful.

https://www.mssqltips.com/sqlservertip/1936/sql-server-database-migration-checklist/

Hi Andreas,

It is not a computed column. I will investigate further what is going on at the Publisher side.

thank you for your reply,

Best...

Hi Bibo Kid,

These links might help you. 

-- Monitoring SQL Server Transactional Replication
https://www.brentozar.com/archive/2014/07/monitoring-sql-server-transactional-replication/

-- Monitor Replication Using Scripts
https://www.sqlservercentral.com/Forums/605381/Monitor-Replication-Using-Scripts

--Checking Replication Latency...

Hi

If you just want to sync few tables, how about setting up Transaction Replication

--Transactional Replication
https://msdn.microsoft.com/en-us/library/ms151176.aspx

-- Setting Up Transactional Replication: A Step-by-step...

Hi Kumar,

There wont be any issue. Once the Server is UP, just monitor the synchronization state.

There was one time that our secondary replica in AAG...

Hi 

How about creating a SQL Agent Job to capture Table Sizes and output as .txt file using the T-sql script provided in the link below.

http://sqlconjuror.com/sql-server-get-table-sizes/

Hi Robin,

No. Bulk logged recovery model will not work in always on. The database must be in Full recovery model before it can participate in an AAG.

Hi Robin,

No. Bulk logged recovery model will not work in always on. The database must be in Full recovery model before it can participate in an AAG.

I agree with Sue_H. You can load the SQL profiler traces to a table in a non-production environment and query it. You may find info on stored procedures that are...

Hi mw112009,

Please try to go to "Reporting Services Configuration...

Hi Thom and Phil,

Thank you for your suggestions. We will check the WMI Event Watcher and File Watcher and test it out.

Best Regards,

Hi

I think I got the answer already. I found the links below that gave me an idea.

http://www.sqlservercentral.com/Forums/Topic638465-146-1.aspx

https://social.msdn.microsoft.com/Forums/sqlserver/en-US/13e50a4f-05bd-4abd-a1d7-73d2abca4013/log-shipping-between-sql-2005-and-sql-2012-log-restore-problem?forum=sqldisasterrecovery

Thanks.

Best Regards,