|
sql
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
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 Is this a server you upgraded to 2005 was a target server and prior to> 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. 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. Show quoteHide quote "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? > >  
Other interesting topics
recent SQL 2005 hotfix creates problem
Hyperthreaded CPU's SATA for SQL Server data SQL Server Agent Not Restarting Automatically SSIS Connection Error MS OLE DB provider for Oracle Cannot create a Stored Procedure set transaction isolation level read uncommitted A couple LDF questions. Help with moving DB from 2000 to 2005 folders |
|||||||||||||||||||||||
