Hello all; thanks for the input thus far; so here's the entire script that is documented; sanity check please...I'm more of a systems guy than a SQL DEV/DBA.

USE [msdb]

GO

/****** Object:...

Thanks Jason/Sue...I know it has something to do with the logical file name. I don't have this issue with SQL 2012 and I kinda bit off more than I could...

Hello all;

SQL pseudo noob here...running into same issue, but only 2008R2. We have a canned script that's been around for years; so in short, DB X is the primary, DB...