Post reply

Backup using Maintainence Plan fails

  • June 27, 2007 at 6:42 am

    #153652

    Extremely grateful for any help. I am trying to create a simple MaintPlan to back up a complete DB using the MaintWizard but is failing and I get the message below.

    Also the version installed is Sql 2k5 9.00.1399.06 (RTM). do I have to fully patch up SP2 in order to get this working?

    Create maintenance plan failed

    Create failed for jobstep 'Subplan'. [Microsoft SqlServer.MaintenancePlan Tasks]

    An Exception occurred while executing a transact-SQL statement or batch.

    [Microsoft.SqlServer.ConnectionInfo]

    The specified '@subsystem' is invalid [valid values are returned by sp_enum_sqlagent_subsystems]. [Microsoft SQL Server. Error 14234]

    Thanks in advance

  • June 27, 2007 at 7:30 am

    #715522

    Hi pls check http://www.sql-server-performance.com/ss_creating_backup_jobs.asp fyi

    [font="Verdana"]- Deepak[/font]

  • June 28, 2007 at 4:34 am

    #715794

    As you have mentioned you are in RTM version, I would suggest it will be better if you apply SP2.

    Minaz

    "More Green More Oxygen !! Plant a tree today"

  • July 3, 2007 at 6:19 am

    #716850

    Applying SP2 and installing the Integration Services did the trick. Thanks all

  • July 6, 2007 at 6:26 am

    #717656

    Also view and install from KB934458 at the very minimum for running maintenance plans. This should bring you up to 9.00.3054.

  • July 23, 2007 at 3:17 am

    #721467

    Lot of Bugs has been fixed in SP1 and SP2. Just check microsoft site for that they have listed number of bugs being fixed in SSIS and MP.

    Cheers,
    Sugeshkumar Rajendran
    SQL Server MVP
    http://sugeshkr.blogspot.com

  • July 25, 2007 at 2:38 pm

    #722423

    Hi,

     

    Even i am facing the same problem, dunno what to do? Please help me !

  • July 25, 2007 at 2:54 pm

    #722425

    Hi,

     

    My SQL version is 9.0.1399

    Do i have to install SP1 first and then install SP2 or Can i install SP2 straight away?

     

  • July 25, 2007 at 3:42 pm

    #722437

    I got this error message when I tried to install SQL Server 2005 SP2

    the image file hotfix.exe is valid, but is for a machine type other than the current machine error message while installing SQL service pack 2

     

    Please guide me

  • July 25, 2007 at 8:06 pm

    #722462

    First you need to install sp1 followed by sp2 in order to full upgrade of binary files.

  • July 26, 2007 at 8:55 am

    #722599

    I got the same error hofix.exe

    even when i tried to install SP1

  • July 26, 2007 at 9:40 am

    #722615

    How do I sort this error

    the image file hotfix.exe is valid, but is for a machine type other than the current machine

  • August 7, 2007 at 6:36 am

    #725109

    I don't believe you need to install SP1 first. From the Microsoft website:

    "Service Pack 2 for Microsoft SQL Server 2005 is now available. SQL Server 2005 service packs are cumulative, and this service pack upgrades all service levels of SQL Server 2005 to SP2."

  • June 19, 2010 at 1:14 am

    #1182419

    suganya-424289 (7/25/2007)

    I got this error message when I tried to install SQL Server 2005 SP2

    <STRONG>the image file hotfix.exe is valid, but is for a machine type other than the current machine</STRONG> error message while installing SQL service pack 2

    Please guide me

  • June 19, 2010 at 1:16 am

    #1182420

    suganya-424289 (7/25/2007)

    I got this error message when I tried to install SQL Server 2005 SP2

    <STRONG>the image file hotfix.exe is valid, but is for a machine type other than the current machine</STRONG> error message while installing SQL service pack 2

    Please guide me

Viewing 15 posts - 1 through 15 (of 15 total)

You must be logged in to reply to this topic. Login to reply