Yes, since you restored a FULL backup, you now need to restore every LOG backup that has occurred since the FULL.

Start looking at this: sys.dm_exec_query_stats

...not sure how much closer you'll be able to get.

ALTER DATABASE [model] SET ENABLE_BROKER;

Should make any new Databases have service broker enabled.

You'd still need to update the rest of the DB's where it's not:

SELECT name, is_broker_enabled FROM...

An old audit, but it still works great:

http://www.mssqltips.com/sqlservertip/1818/script-to-auto-generate-a-security-report-for-your-sql-server-instance/[/url]

Check out the sys DMV's dm_exec_cached_plans, dm_exec_query_stats, etc.

Find the last restored file from https://msdn.microsoft.com/en-us/library/ms188004.aspx

Then manually restore the chain of LOG backups up to the most recent one. You can also configure log shipping to automatically restore...

ALTER DATABASE [DATABASE] SET COMPATIBILITY_LEVEL = 100

Try upping your session timeout for your backup failures to network storage:

http://technet.microsoft.com/en-us/library/cc938292.aspx

You could configure an alert for Error 5084

EventID: 5084

Severity: 10

Logged: Yes

Message: Setting database option %ls to %ls for database %.*ls.

https://msdn.microsoft.com/en-us/library/cc645602(v=sql.100).aspx

I had issues log shipping from 2005 to 2012. I believe the official limitation is two major versions. I.E. 2005 + 2 major versions is 2008 R2.

A LOT of vendors get really confused about the word "truncate". 1/2 the time when they say truncate they mean, "take a LOG BACKUP". You might just want...

Have you tried pointing it to the listener DNS name?

You could just add some string concatenation to build the statements you need to run off of this:

select name, suser_sname(owner_sid) as owner, [Put your string concatenation here] AS [Statement to...

Well, the plot thickens. defrag L: -v works, it's the analysis part (-a) that fails.

Optimize-Volume -DriveLetter L -Analyze -Defrag -Verbose is actually running defrag (-Defrag).

Optimize-Volume analysis only fails too...

http://jonmorisissqlblog.blogspot.com/2015/02/the-slab-consolidation-trim-operation.html