web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Microsoft Dynamics RMS (Archived) / Rebuilding a Corrupt ...
Microsoft Dynamics RMS (Archived)

Rebuilding a Corrupt RMS Database

(0) ShareShare
ReportReport
Posted on by Community Member

I have a RMS database which has some tables which have been renamed from dbo.xxx to RMS.xxx. At this point it is a mystery how this happened but we have unusual problems with RMS that are suspected to be related to this change. The DB will not reindex as it fails to find some of the default tables that have been renamed.

My VAR has opened a case  at their level w/ MS to look for solutions but I am interested in an end run around trying to repair  this DB.

Is it possible:

1: to drop these improperly named tables and re-add them with the correct names?

or

2: Can the DB data, customers, items, POs, sales history, etc, be exported and then imported into a newly created DB? Other major DBs such as Oracle have this feature. How can this be accomplished w/ SQLServer 2005?

 

This DB dates back to 2002 when it was originally created so it has been around and has a lot of items and history in it.

Surely there must be a strategy for dealing with a problem with this. My VAR has suggested to leave it alone and live with it but I feel that is just sweeping the problem under the rung and it will eventually turn into something unresolvable.

All ideas welcome please.

Thanks

 

*This post is locked for comments

I have the same question (0)
  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Try creating a backup of the current database or starting from a blank install then using the Enterprice Manager tool from the SQL trial download to make corrections or fix tables.  Download from www.microsoft.com/.../trial-software.aspx

  • Community Member Profile Picture
    Community Member on at

    I have backups of the DB and have created a test DB using SQLServer 2005 EM but the issue is how to recreate the original tables from the 38 misnamed tables and do this w/o loosing any data.

  • Suggested answer
    Community Member Profile Picture
    Community Member on at

    Enterprise Manager can rename tables, but I think you will have better results by starting with a fresh install and using the Export Data feature of EM to migrate data from your failed database into the correct tables of the working database.

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at

    From the description, it does not sound like this is a problem with the naming of the tables.  The dbo portion of a database table name is the schema it is associated with.  dbo stands for Database Owner.  All you need to do is fix this is to open up the database in SQL Management Studio, right-click one of the tables affected, go to Design.  Then in the Properties pane, set the Schema back to dbo, close the Designer view and save the changes.

  • Community Member Profile Picture
    Community Member on at

    When I right click the table and enter Design, I do not find anything that allows me to set the Schema back to dbo. What am I missing here?

    Thanks,

    Richard

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at

    If you don't see the Properties window, go to View -> Properties window to have it show up.

  • Community Member Profile Picture
    Community Member on at

    Aha. Ryan, that allowed me to see the Schema name and change it as you described.

    After I changed the name I was informed existing permissions would be wiped. Will they be reapplied when I finally get re-index from RMS Administrator to run w/o failing due to the table name/ownership issue? Should I be concerned about this message?

  • Ryan Sakry Profile Picture
    Ryan Sakry 3,425 on at

    You'll want to test this on a backup before doing it on the live database, but changing the schema back to dbo will reset the permission, but by default dbo has access to all the tables it owns.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Congratulations to the November Top 10 Community Leaders!

These are the community rock stars!

Leaderboard > 🔒一 Microsoft Dynamics RMS (Archived)

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans