alejandro-jasso (10/12/2014)
Hi Perry,I tried doing your suggestions.
I allowed maintenance plan to finish, I stopped LS during this time. Once Maintenance was finished, I took differential Backup but still this backup is 180GB. Transfering this huge file and then restoring it will not allow me to have DB synchonized within reasonable time. Considering that after file transfering, DB restore, LS will take several hours to bring changes on secondary DB.
I'm guessing you have a maintenance plan around the sametime that also has a full backup task in there somewhere?
If this is the case then the diff option wont work as it will be based on the new full in the maintenance plan and not the secondary database on the secondary instance.
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉