I have 2 SQL 2016 instances that have have Minion Backup installed from the same installer. I've done a schema compare and both Minion databases are identical. The first instance is on SP1 (13.0.4001.0) the second is on SP1 CU 2 (13.0.4422.0). Everything works awesome on the first instance. On the second instance, I'm getting an error that I've tracked down to the the Minion.BackupStmtGet stored procedure. If I run the command
@DBName = 'model'
, @BackupType = 'Full'
then I get the following error:
Msg 213, Level 16, State 1, Procedure BackupStmtGet, Line 947 [Batch Start Line 0]
Column name or number of supplied values does not match table definition.
Everything that I can think to check is identical (server configs, Minion settings tables), except the SQL version. Is this a known issue with this version, or is there something else I've missed.
Thanks in advance!
Thanks for letting me know this. I’ll get CU2 loaded and get this fixed for you. Stay tuned and I’ll have something soon.
I’ve looked at one of my lab boxes that already has CU2 on it, and MB works just fine on that box, so I’m unable to repro. There may be an issue with your config, or with powershell on that server.
Try running this and see if you get anything back. You need to call the SP with 3 params, not the 2 you sent me.
@DBName = ‘model’
, @BackupType = ‘Full’, @DBSize = 1
Let me know what happens with that and it’ll help me determine what to do next.
Hey Andrea, while I understand what you’re saying, I don’t know how you came to that conclusion. If that were the case, then nobody should be able to run the code, and you shouldn’t either. As you said, it works just fine on your first instance but not on the second. Why would that be if the cols were mismatched?
Closed due to inactivity.