SQL Server Performance

Consolidating multiple log files into one

Discussion in 'General DBA Questions' started by alexjamesbrown, Nov 23, 2009.

  1. alexjamesbrown New Member

    I've taken over the job of administering our main SQL instance we use for our ERP application (Dynamics NAV)
    The install has many files listed in the database properties - files section.
    Here is a screenshot:

    http://twitpic.com/q8ktj/full

    Is there any way i can consolidate these files into a standard MDF and LDF file (on different drives perhaps)

    (i should add - it wasn't me that set this instance up!)
    The one located on the G: drive is the largest. Ideally, I just want this log file.
  2. moh_hassan20 New Member

    initially create full backup for the database, backup log (if database are full recovery model to free it)

    use the ALTER DATABASE statement to remove the log file
    example
    ALTER DATABASE navision4
    REMOVE FILE navision4_log
    ALTER DATABASE navision4
    REMOVE FILE navision4_log2

Share This Page