How to Change sbo-common ldf & mdf path

[Former Member]

Dear experts,

Our C drive space is very low, that why I want to change my sbo-common .ldf and .mdf data path( Its hold 15gb).

I had changed other .ldf and .mdf path using restore process. But when I change the sbo-common path then error is occurred (database are use).

I run the SP_WHO and find out the spid and kill the IDs but one or two id was create again that's why

I not change the path.

Please give me the solution.

Tanks ,

Arabinda Pal

[Former Member · Accepted solution]

Dear Arabinda,

Databases are in use means

1. SAP B1 is running

2. SQL server service is running.

Go to services.msc and stop SQL server service. Finish your work and resume again.

[Former Member]

Hello Dreamlite Inter...

It is the best way which is explain by Neetu Dhami

Thanks

Manvendra Singh Nirajan

Edited by: Manvendra Singh Niranjan on May 22, 2011 12:36 PM

[former_member206488]

Hi,

Close SAP on server and client machines.

follow below steps:

Always take a full backup before a detach.

Detach the database, delete/rename the log file, attach the database - this will create a minimum size log file.

Note that the log file must be deleted/renamed otherwise it will be re-used even though it is not mentioned in the attach.

Enterprise manager

Right click on the database, All tasks, Detach database, OK.

Delete/rename the disk log file.

Right click on databases, All tasks, Attach database, Select the .mdf file, OK, Yes (to the create new log message).

t-sql

sp_detach_db [dbname]

Delete/rename the disk log file.

sp_attach_single_file_db [dbname], [filename]

where [filename] is the name of the physical data file (.mdf).

Thanks,

Neetu

[kvbalakumar]

Hi,

Close all SAP windows (clients too)

Restart the SQL Server through SQL Server management studio.

Backup and restore the SBO-Common dB.

Note: If the ldf file looks more larger then try this

1. Detach the SBO-common dB.

2. Move the ldf file to different location (than that of mdf file)

3. Now attach the dB with mdf file alone

4. System will automatically create new ldf (with size less than 1 MB)

5. If everything works fine, you can delete the ldf file(which was moved earlier)

Regards,

Bala