Thanks for your reply Perry but the issue is not with the tape, that is fine.

The issue occurs when the BAK file is restored into the database.

Hi,

I have tried this but I do not have a table called log_shipping_plan_history.

I have looked under the available tables from the MSDB database and this is not one of them.

I...

Thanks Mani but I might not have been clear enough.

I don't want to email everytime a log goes gets applied to the secondary DB.

Within SQL 2005 there is a "transacation...

I have worked out how to do this using the SQLCMD utility within SQL2005.

We used to use iSQL and needed a new way.

All sorted now.

Thanks,

We are not using a monitor server

That did work!

Thanks again Amit

Will give it a try!

Thanks Amit