I have some problem setting up log shipping. I am user SQL management studio to it up. I have restore the DB and create the log shipping job.
I see the logs are being copied but I don't think that are been applied to the DB.
6/30/2010 22:00:00,spid66,Unknown,The log shipping secondary database DB1 has restore threshold of 45 minutes and is out of sync. No restore was performed for 72 minutes. Restored latency is 0 minutes. Check agent log and logshipping monitor information.,
I tried to restore the log manually database->task->restore but the 'transaction log' button is disable
Thanks in advance for any help