I did this a few weeks back. It might be worth taking a look at your autogrowth settings for the log file. I typically set mine to 128mb to 256mb...

Note while shrinkdb is typically not recommended, it is recommended to take a look at index fragmentation after the fact and rebuild / reorg as necessary. I would probably just...

I am getting this alert in SQL 2016 SP1 CU7.

I don't have any issues reported and can not find anything wrong. 

Found this on stackexchange.

.

Now when you say just the top part of the script... do you mean just the enabling the database as the logshipping database and configuring the backup job?

Or...