Odd tables in DB

B

Bob

RI have taken over as the DBA on a MSPS instance. In my database there are
some groups of talbes that I don't think should be their. I can't link them
to anything in MSPS and they are probably from some tutorial. The three sets
begin with DB_, OBJ_, and UNV_.

The DB_ tables are DB_PENDING_JOBS and DB_USER_LIST

The OBJ_ tables have names like OBJ_M_ACTOR and OBJ_M_CHANNEL

The UNV_ tables have names like UNV_RELATIONS and UNV_TAB_OBBJ

Is anybody familiar with these tables? Am I free to delete them?

Thanks
 
J

JackD

You can check against the srvrdb.htm and projdb.htm documents and see if
they are referenced there. I don't recall seeing those names before, but do
a back-up before you delete them!
 
J

JackD

You can also check the setup scripts that project server install uses to set
up the database. If they aren't created by the scripts then they don't need
to be there.
 
B

Bob

Thanks for the suggestions Jack.
I should have mentioned that I had checked the html files, and even dumped
all the stored procedures. Saw no mention of these in the setup scripts so I
think they are on their way out, after a backup of course.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top