SQL 2005 SP1
Management Studio 9.00.1399.00
OS is Windows Server Enterprise SP2 running on a 32 bit machine.
When SQL 2005 was installed a few months ago, it was installed on C:\Pgrm Files. I have another much larger drive (D) that I store the databases on as well as the backups. We had a contractor come out to migrate a very important database from our SQL 2000 server to this one. After I finished migrating a few others (SQL 2000 flavor) and two test sites, I noticed not all my databases were showing up for the wizards or when I attempt to create a maintenance plan manually. The database which the contractor migrated threw a job clock sub routine in the database which calls for it to be backed up nightly. (The contractor quit a week later and now who knows where he is - I have no idea how to do what he did anyway, so....)
I've exahusted white papers, read forums and blogs. I've asked a DBA and two others that I know around town who have SQL 2005 servers all to no avail. I've tried to detach and reattach, create a new backup user and associate it with the databases and even move a database to C:\Pgrm Files\Usoft SQL Server\MSSQL.1\MSSQL\Data to see if it would make a difference. It...makes...no...difference.
All databases have the same owner, which is a domain admin username. All have the same role name and role member for backup operator.
I could have easily missed something being a newbie to Sequel. If there's any other information you all need, I'll be more than happy to supply it!
Thank you in advance.