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.
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