Viewing 15 posts - 121 through 135 (of 1,584 total)
Thanks for clarifying Luis, as always appreciate your insight! I'll take a look and see where I can make improvements to the process and take that back to the...
January 27, 2015 at 1:10 pm
Not sure what you mean there Luis. There could be 300 different columns in the ReportColumns table and I wasn't sure how best to link them all together
I didn't...
January 27, 2015 at 11:42 am
Sorry that's only if you were using the GUI...
What is the spid currently doing?
January 27, 2015 at 10:50 am
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...
January 27, 2015 at 10:24 am
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...
January 24, 2015 at 12:32 am
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,...
January 23, 2015 at 7:32 am
Right before you send the email, add:
SELECT
@database_name, @server, @SubjectHTML, @tablecopyHTML, @tablerestoreHTML
EXEC msdb.dbo.sp_send_dbmail...
Etc.
January 22, 2015 at 10:10 pm
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...
January 22, 2015 at 7:32 am
I was referring to your error after running the Satnam's script
January 22, 2015 at 7:08 am
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
January 22, 2015 at 5:30 am
Wahoo got lucky today! (kidding) - Thanks for the question 😀
January 22, 2015 at 5:27 am
However, I've stated earlier, I've another secondary db from different system, it's totally another separate system
Is the MSSQL version different or the same as the secondary that works?
January 20, 2015 at 5:36 pm
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...
January 20, 2015 at 8:00 am
Try running it on the primary, or changing the data type for that parameter to nvarchar(10) instead of a bit
January 20, 2015 at 5:26 am
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...
January 19, 2015 at 8:44 pm
Viewing 15 posts - 121 through 135 (of 1,584 total)