Backup Wizard 2005 Standard

I have a new installation of SQL 2005 standard and I cannot create an
automatic backup. When I launch the wizard I get an error " Failed to
retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
then create my backup job, but upon completion I get these 2 error:
Invalid column name 'from_msx'.
Invalid column name 'has_target'.
I have to manually launch the backups each night and that work fine. I
previously was using Sql 2000 and the backup jobs ran without any problems.On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> I have a new installation of SQL 2005 standard and I cannot create an
> automatic backup. When I launch the wizard I get an error " Failed to
> retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> then create my backup job, but upon completion I get these 2 error:
> Invalid column name 'from_msx'.
> Invalid column name 'has_target'.
> I have to manually launch the backups each night and that work fine. I
> previously was using Sql 2000 and the backup jobs ran without any problems.
Is this a server you upgraded to 2005 was a target server and prior to
upgrade did the server have master server?|||No this is a new Server not an upgrade. I moved the 2000 db over to this
server.
"Bulent" wrote:
> On Apr 19, 1:40 pm, Todd <T...@.discussions.microsoft.com> wrote:
> > I have a new installation of SQL 2005 standard and I cannot create an
> > automatic backup. When I launch the wizard I get an error " Failed to
> > retrieve data for this request. (Microsoft.Sqlserver.SmoEnum) Invalid column
> > name 'msx_job_id'. (Microsoft SQL Server, Error: 207). I click okay and I can
> > then create my backup job, but upon completion I get these 2 error:
> > Invalid column name 'from_msx'.
> > Invalid column name 'has_target'.
> >
> > I have to manually launch the backups each night and that work fine. I
> > previously was using Sql 2000 and the backup jobs ran without any problems.
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>