Delete Database & Company

[Former Member]

Hello Experts,

We have created multiple company databased to test certain functionalities. Now we have to delete the unwanted databases. I have observed that deleting databases from B1 screens is not possible.

What is the procedure to carry out this activity? Are there any dependencies?

Thanks in advance

With Regards,

Kaatss

[Former Member · Accepted solution]

hi kaatss,

close your SAP B1.

in SQL 2000

-

---

1. Start =>Programs => MicrosoftSQL server =>Enterprize manager

2. Click on Database options.

3. Select the database you need to delete.

4. Right click and delete the database.

in SQL 2005

1. Start =>Programs => Microsoft SQL Server 2005 =>SQL Server Management Studio Express.

2. Click on Database options.

3. Select the database you need to delete.

4. Right click and delete the database.

then

Open your SAP B1

Administration => choose Company

Press the refresh button.

you can see the deleted database and company will be removed.

[Former Member · Accepted solution]

Thanks a lot Sandip

Will the refresh action remove entries made in SBO-COMMON database or we have more activities to be done there?

With Regards

[former_member201110 · Accepted solution]

Hi Kaatss,

Yes, the Refresh button updates the SBO-COMMON database so you don't need to carry out any other steps.

Kind Regards,

Owen

[Former Member · Accepted solution]

Its safest to keep the delete company functions far away from the normal user GUI, you never know!