If you didn't check the box to generate the snapshot immediately then it should be relatively quick, it you generated the snapshot, it would depend on the amount of data...

Anywhere before the send email portions of the script

Here:IF(@time_since_last_backup>15)

BEGIN

<< The code I asked you to run goes here >>

EXEC msdb.dbo.sp_send_dbmail

The code has multiple places where the sp_send_dbmail is executed...

You need to do something debugging. Is there any one else at your shop that can assist you with this?

The fact that all those variables are blank is strange,...

Right before you send the email, add:

SELECT

@database_name, @server, @SubjectHTML, @tablecopyHTML, @tablerestoreHTML

EXEC msdb.dbo.sp_send_dbmail...

Etc.

If the email is empty, check the variables used in the email portion of the script - chances are of of the variables used in the @body is NULL, causing...

I was referring to your error after running the Satnam's script

Also, if you had it error out, you will need to run the d-r-o-p table #logshipping_status_manual statement to remove the reference to the temp table

Wahoo got lucky today! (kidding) - Thanks for the question 😀

Is the MSSQL version different or the same as the secondary that works?

Peter, your post on 1/13/2015 9:30 PM showed that you were receiving the email (which means the code did work at that time) - can you try running the original...

Try running it on the primary, or changing the data type for that parameter to nvarchar(10) instead of a bit

I no longer use log shipping (which is kind of why I can't remember the details (sorry )) ; but yes you will need to have a linked server in...

anoop.mig29 (1/15/2015)Hi MyDoggieJessie

I have basic question where to execute the code you provided on secondary server ???

does it requires witnesses server to be present ????

I am getting below...

Peter2012 (1/15/2015)

Could you help to fix this problem?

Perhaps need to convert...

"COUNT()" returns total number of rows, irrespective of the contents...unless a specific column is specified that contains a NULL value, then those will be omitted