Post reply

Maint Plans Problems After Moving System Databases

  • September 28, 2009 at 3:42 pm

    #210206

    Hi Folks

    i am need of some assistance after i moved my system databases as well as the logs as well as mssqlsystemresource and distmdl databases and logs

    i thought everything looked fine as i checked file locations, registry and physical locations

    until i tried my Maint Plans and got this nasty error

    Failed to retrieve data for this request. (Microsoft.SqlServer.SmoEnum)

    ADDITIONAL INFORMATION:

    An exception occurred while executing a Transact-SQL statement or batch.

    (Microsoft.SqlServer.ConnectionInfo)

    Invalid column name 'from_msx'.

    Invalid column name 'has_targets'. (Microsoft SQL Server, Error: 207)

    Has anyone received this type of error before or am I the only one that blew the move ?

    Any assistance would reeeeeeeeeeeelly be appreciated.

    Thanks

    Jim

  • September 29, 2009 at 12:12 pm

    #1059659

    Guess no one has seen this one

    thanks

    jim

  • October 2, 2009 at 2:53 pm

    #1061202

    is this SP2 and on a cluster by any chance?

    see

    http://social.msdn.microsoft.com/Forums/en-US/sqlgetstarted/thread/f2731ce1-45a9-4c72-b7ff-c302d9fc0025

    upgrade to SP3 might also be an option.

    be sure all the master and resource database files are in the same directory.

    ---------------------------------------------------------------------

  • October 5, 2009 at 9:06 am

    #1061804

    Hi george sibbald-364359

    Everything i found said to upgrade tp SP2 but I was already on SP3

    So as a last resort i re-applied SP3 and it fixed the Maint Plans for some reason

    They all showed up and no errors

    I don't how but it worked.

    Thanks

    Jim

  • October 5, 2009 at 9:15 am

    #1061812

    JC-3113 (10/5/2009)

    Hi george sibbald-364359

    Everything i found said to upgrade tp SP2 but I was already on SP3

    So as a last resort i re-applied SP3 and it fixed the Maint Plans for some reason

    They all showed up and no errors

    I don't how but it worked.

    Thanks

    Jim

    Sounds like it reapplied changes after you done the move.

    --------------------------------------------------------------------------------------
    [highlight]Recommended Articles on How to help us help you and[/highlight]
    [highlight]solve commonly asked questions[/highlight]

    Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
    Managing Transaction Logs by Gail Shaw[/url]
    How to post Performance problems by Gail Shaw[/url]
    Help, my database is corrupt. Now what? by Gail Shaw[/url]

  • October 5, 2009 at 10:15 am

    #1061861

    Hi Ten Centuries

    guess so

    luckily that was my test

    i think i will leave the production one alone

    Jim

Viewing 6 posts - 1 through 5 (of 5 total)

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