Skip to Content
author's profile photo Former Member
Former Member

DATA Log file path change in sql

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.

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Posted on Jun 26, 2011 at 07:32 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jun 28, 2011 at 02:13 PM

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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Jul 02, 2011 at 04:35 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.