> I have almost got log shipping working (SS 2000) but have one last issue to
> go.  First of all, all jobs that log shipping set up on my primary server are
> working.  And on the secondary server all jobs are working except for the
> "Log Shipping Restore for PrimaryServer" but doesn't give any useful details.
>  However, when I go into the Log Shipping Monitor (which is on the secondary
> server), I get this error msg:
>
> "[Microsoft SQL-DMO (ODBC SQLState: 42000)] Error 4306: [Microsoft][ODBC SQL
> Server Driver][SQL Server]The preceding restore operation did not specify
> WITH NORECOVERY or WITH STANDBY. Restart the restore sequence, specifying
> WITH NORECOVERY or WITH STANDBY for all but the final step.
> [Microsoft][ODBC SQL Server Driver][SQL Server]RESTORE LOG is terminating
> abnormally."
>
> I set up my database on the secondary server by restoring from a backup that
> I took from the primary (with recovery btw).  I then put this database into
> "Read Only" mode. 
>
> Does anyone have any idea what I am doing wrong?  It's creating the log
> backups on the primary, copying them over but then gets stuck trying to do
> the restore on the seconday.  I'm so close...
>