DATA Log file path change in sql

[Former Member]

Dear experts,

due to non avaibility of space in disk i have move my SAPLog file in another drive, but now my SAP working fine but when i try to change path in SQL 2005 its not giving me permission to do.

please let me know how to change log file path in sql 2005.

& if infuture i change my SAP 1 DATA file path how we change configure new path for dabase in SQL 2005.

Regards,

jitendra.

[Sriram2009]

hi

Kindly go thru the SAP notes

Note 625546 - Size of transaction log file is too big

Note 1353149 - How to truncate the database log size if it become too large

Regards

S

[patelyogesh]

Can you please explain how are you trying to change log file location? through SAP or SQL manager.

[Former Member]

i m using sql manager

[patelyogesh]

Please try to login to DB through <sid>amd user and see its allow you to change location. If not then use SA account.

Please let me know if you still have question.

Regards,

Yogesh

[Sriram2009]

Hi

Kindly go thru below web links. before start the process stop the SAP instance.

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

Set the log DB size - http://help.sap.com/saphelp_nwce72/helpdata/en/f2/31ad9b810c11d288ec0000e8200722/content.htm

and ref the SAP Note 363018

Regards

Sriram