Create a New Log file from a Command Line

If the log file is too large and you want to create a new log. Detach the database. Rename the old log file to something like jpegger_log1.ldf (or move it to another directory). Then from Management Studio, open a new query and enter the command:

create database [jpegger] on (FILENAME = ‘C:\jpegger.mdf‘) for attach_rebuild_log

where jpegger is the name of the database and ‘C:\jpegger.mdf‘ is the path for the mdf file surrounded by single quotes(‘).

This website and its content is copyright of ScrapDragon, LLC - © ScrapDragon, LLC 2018. All rights reserved. Any redistribution or reproduction of part or all of the contents in any form is prohibited other than the following: You may copy the content to individual third parties for their personal use, but only if you acknowledge the website as the source of the material. You may not, except with our express written permission, distribute or commercially exploit the content. Nor may you transmit it or store it in any other website or other form of electronic retrieval system.