cancel
Showing results for 
Search instead for 
Did you mean: 

User table belonging to dbo schema were found in database

Mofizur
Contributor
0 Kudos


I was performing System Refresh using backup/restore method.While running sapinst on DB host I was getting below error

    

Database Environment :-MS SQL Server 2014 (MS SQL 12.0)

Solution:-

SAPINST expects only tables in schema of your DB. I found that We have user tables in schema 'dbo'.

Run this statement to find out what tables SAPNST has a problem with:

use <DB SCHEMA NAME>
go
select * from sys.tables where schema_id = schema_id('dbo')

    

You can export them or Delete them.I deleted them and went ahead with the installation.

Use below command to delete them

drop table dbo.sap_dblocks ,dbo.sap_mon_para,dbo.sap_tsize_sample,dbo.sap_mon_text,dbo.sap_tabstats,dbo.sap_tr2_tracedefs

Now check again if theye are indeed deleted or not.

Accepted Solutions (0)

Answers (1)

Answers (1)

nirmal_konchada
Active Contributor
0 Kudos

What is the question here or was it just a article to share the knowledge?

Regards.

Nirmal.K