Can some one share the T-SQL scripts for automating Transaction Log shipping backups on source, copy and restore on destination ( as standby for reporting purposes )?
I need to do it for ongoing 200 DBs on production instance which need to be shipped to DR SQL Server. I tried with GUI, script etc. but it doesn't seem to be working as expected, the DR DBs are always out of sync or do not have the Data as needed!
Logshipping is frustrating!
Thanks in Advance