Changing location DB SBO-Common

[Former Member]

Hi all,

Detailed problem description:

I am using SQL Server 2005.

To free space on the C drive we want to move mdf (data) and ldf (log) files for example 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data'

to the D-drive, 'D:\Data'.

I know SBO-Common is necessairy for SBO, the others not sure.

How can I move those files, without creating any problems?

Thanks, Chief

[former_member583013]

You do not need to move SBO Common.

The SAP company database can be moved anywhere without requiring to move SBO common

[Former Member]

I need to move the SBO-COMMON database because the disk-space in C:\ almost empty so i want to move to other disk (D:\)

[Former Member]

Hi Chief

Accutally I think it's a SQL Server job and you do not even need to change anything

in SBO.Just relocate the DB to the new location by following the below MS kb,

then click the refresh botton the choose company windows at SBO.That should work.

http://support.microsoft.com/kb/224071

Regards,

Syn Qin

SAP Business One Forums Team

[Former Member]

It is possible. There are two ways how to achieve it:

1. set the database to single mode to prevent some problems. Copy the mdf of sbo-common to other drive.

On SBO-COMMON right click, properties, Files, Add, select the mdf you copied. Set as primary and remove the old path.

2. make backup of sbo-common. Then under the same db make restore and on seccond tab set new location.