2012-12-26 09:52 AM
After upgrading an very out of date version of SMSQL I noticed that my backups stopped working. They were setup by a consultant so it took me a bit to find out they were scheduled via the SQL Jobs and were using a script calling on smsqlbi.exe that has disappeared. Has this executable been renamed or replaced?
Solved! SEE THE SOLUTION
2012-12-27 01:53 AM
Yes, all newer versions of SMSQL use PowerShell cmdlet, smsqlbi.exe is gone. If you have existing scheduled backup jobs, under SMSQL installation directory, run SMSQLUpgradeJobs.exe, you should be able to use that tool to convert/upgrade smsqlbi.exe job to new backup job.
It may be easier to just recreate backup job from new SMSQL GUI.