Hi guys,
I have configured log shipping on SQL Server 2000 Standard Edition Server by using article posted sqlserverperformance website(Linked Server Concept).
The Scheduled operation on Restoring Log Backup was failed since it doesn't get the exclusive access of Database(Log Shipping Configured for Reporting Server)

So,i try to restore the log backup manually to bring back the Reporting Server.When i restored log backup its shows message Log successfully restored but after the log restore the Database status chnaged to Suspect mode.The same problem happended two times this week.i could not able to find out the reason.
Also,i am facing another problem like whenever i try to restore the log backup in sequence like 9.00Am,10 Am,11 A.M.
I am able to restore the first logbackup that is 9 Am. But,When i try to restore 10 A.m log backup its give LSN error.

These two problems leads me to set the logshipping from scratch.
Would you guys able to give some note to this problem.
All your help is highly appreciated.



Thanks,
Prabhakaran

Have you try looking at your error log? Also use the link below to help with the suspect database.

http://www.devx.com/vb2themax/Tip/18624

Jaime E. Maccou