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

Free Space On server

Hi all,

Our server is running out of space because of the log files and I have to manually shrink the log files for all the database almost everyday. We are planning to upgrade the server but also, in the meantime, I would like to know whether I can change the default path of the log files to a different drive and if yes, how to proceed?

Thanks in advance,

Joseph

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Jan 27, 2010 at 04:21 AM

    Hi!

    You can move your mdf and ldf files to different Location.

    1. Open MS-SQL Databse

    2. Enable Object Explorer

    3. Right Click on your Company DB and select Detach, before doing detach please ensure that you are logged in to the databse via, SAP B1,New Query Window,Stop Mail Services,Stop Backup Services of SAP.

    4. After Detaching, your DB will detached from the Databse List of MS-SQL

    5. Now, go to your Installtion Path of MS-SQL Server Database.(C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data)

    6. Cut the mdf and ldf file of your database.

    7. Paste the same in different Location.

    8. Open MS-SQL Database.

    9. on Object Explorer, Right Clik on the Data Base

    10. Select Attach

    11. Map the mdf path of your company DB

    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.