I have a question about log shipping and need your advice.
I set up a log shipping to copy the whole database from 1
server to another and have trouble with restoring the new
changes. I used the primary server as the source & monitor
server and a secondary server as the destination server
where the data are copied to. What i did was:
Go to SQL server enterprise Manager -->Management
-->database Maintenance Plan and create a new maintenance
for log shipping. It copied the database to another server
ok but not when you make a change in the primary server.
The changes didn't show up on the secondary server and i
got error :"Executed as user: MSA1\Administrator. The log
shipping destination MSANINE.MAI is out of sync by 10285
minutes. [SQLSTATE 42000] (Error 14421). The step failed."
Any suggestions that i may use?