Delete unwanted DB objects.

[Former Member]

Hi guys

I installed SAP NW711 with win/sql 2005.

During SAP Database instance installation, I selected Existing database "A71" instead of new Database"AJ1" creation.

So it created many tables,schemas,views for "AJ1" under A71 Database.

I want to delete those AJ1.database related objects/users/schemas under A71 DB. how to do it.

I am worried if direct deletion will affect the existing database A71.

Any good queries available in SQLServer 2005 to delete all those unwanted things?

pls confirm

regards

[Former Member]

thanks

[Former Member]

By deleting only tables (database) etc will make your installation incosistent. isn't it? How are you planning to create database AJ1?

[Former Member]

When i installed AJ1 created new Database with AJ1, but while creation it asks for cleaning the AJ1 objects in existing A71 Database. I said yes, but it did not clean all the AJ1 objects in A71 database.

I was just wondering what exactly it does to clean Aj1 objects.....Thats my problem.

[Former Member]

Hi,

My opinion is that you corrupted your A71 database.

You should just restore the A71 database and not try to repair it...

It should be easier and safer.

Regards,

Olivier

[Former Member]

Hi Olivier

Could you please tell how to restore the Database...Is there any option in SQLServer studio or SAPINST tool.

Please suggest me your ideas.

regards

[Former Member]

It will be a kind of DB refresh for you. You may try

Enterprise management studio->database->Select database->right click->tasks->restore->database.

You may want to consider taking backups before doing restores.

[Former Member]

Hi guys

Under A71 database

i have SAPAJ1DB.BC_CMSRTS

SAPAJ1DB.BC_COMPVERS

....................etc

finall y A71.usr01

A71.usr02

....................etc

I want to delete only tables related to SAPAJ1DB.XXXX etc.

pls let me know how to drop it.

Is there any option in Sapinst uninstall to remove unwanted tables and databases?