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 ca
n
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:[vbcol=seagreen]
> 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 colu
mn
> 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.[/vbcol
]
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:
> Is this a server you upgraded to 2005 was a target server and prior to
> upgrade did the server have master server?
>
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment