Log shipping SQLserver 2005

SiemensSEN
SiemensSEN used Ask the Experts™
on
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

Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
Make sure you restore the databse with NORECOVERY option when you restored full database on to the tartget server.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial