I have a SQL log-shipping High availability setup from a Primary Server to a Secondary Server which ships transactional logs every 1 hour. Both the databases are running on SQL Server 2008 R2.
According to my understanding every changes that are commited on the Primary Server should reflect on the Secondary Server. Today I ran Redgate SQL Compare to compare the two databases and discovered 38 objects which are inconsistent between the two servers. So I waited for 1 hour for the next restore to be completed on the secondary server. Even after all the log backups have been restored to the Secondary server, the two databases are not identical.
I created a test table on the primary database to see whether it will be created by the restores on the Secondary server, but it is not created even after many restores..
Hourly backup is taken without any errors, and None of the transactional logs on the Secondary server is failing.
Is there any fault on my Log shipping setup ? Where to start troubleshooting ?
What might be the case ? Please suggest..