Replace Engagement20.dbo.fn_GetIntTableFromList with string_split. I thought I removed that reference years ago but some how it's still there.

Thanks Grant! I'm really excited about the articles getting a second life and am glad to see feedback.

Hi kris386,

I've been using these xe's for many years on my production oltp & olap servers and have not had any issues. They are light weight and I wouldn't expect...

Thanks andrew04.
The next part is coming out next Thursday and the final one on the Thursday after that.

Hi clappin,

First, thanks for commenting on my article.

I do not see anything inherent in the scripts or in how log shipping works that would prevent you from doing this on...

Steve,

Great article. Thanks for sharing.

Hi Imacdonald,

First, you should create the 3 jobs (backup on primary, restore & copy on secondary).

Then you should setup the first database for log shipping using the wizard and...

Hi Imacdonald,

Yes I agree, including that you needed to enable xp_cmdshell would have been helpful.

For all 3 scripts, backup, copy, and restore, you need to REPLACE "SQL_Primary_Server" and "SQL_Secondary_Server" with...

Thanks carmstrong592. That's exactly what I was going for.

reggie burns-317942,

Yes, that's correct the databases will still be out of sync.

The last step to get your DBs in sync is to manually copy over all the transaction log...