Nov 3, 2009 at 10:06 PM
Edited Nov 3, 2009 at 10:23 PM
Got some additional information now. i tried running it from a command prompt and it crashes as soon as I try to run it with the error that it cant find Microsoft.Sqlserver.SMO, version =220.127.116.11
Does expressmaint need specifically the 2005 version of this? Because this is a win2k8 server with sql 2008 on it - i tried installing the 2008 SMO package but it's already installed. I haven't tried installing the 2005 version yet since i wasn't sure if
there would be any issues installing it on a server with 2008 already on i t.
and it looks like this post answers my question:
Still have one question though. The post on that blog entry says to install the service pack 2 update 5, but links to service pack 2 update 9 BUT it looks like the newest update is service pack 3 update 4:
So should i install that rather then the sp2 updates?
I tried running expressmaint now (without the update package) and it doesn't crash now but it doesn't work either. Instead of my backup files I get a text file with the message:
Failed to connect to server localhost\sqlexpress.
This SQL Server version (10.0) is not supported.
Expressmaint finished unsuccessfully at 11/3/2009 5:13:34 PM with Return Code(-3)
And now i have it working finally - didn't realize there was a build specific for 2008 now