CREATE A NEW LOG FILE FROM A COMMAND LINE

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(‘).

    • Related Articles

    • Add a new Driver to Dispatch for Mobile Portal

      Create a Position for "Mobile Driver" Assign the User to the "Mobile Driver" Position In the Dispatch Module select "Configuration" then "Drivers" Select the "+" to create a new driver and the Spy Glass to search for the User you want to assign to ...

    • How to create a suspect list for Jpegger

      The suspect list is one of the most powerful tools available for reviewing images in Jpegger. The suspect list is a CSV formatted list that can be generated from any source. It must have at least two fields and the first field must be the ticket ...

    • Unable to open file error Messages when logging on to Scrap Dragon

      There can be a variety of reasons that Scrap Dragon might not be able to open all of its files.  Most common are issues with the network, permission issues, and corrupt files. Make sure that the network dragon folder is shared and everyone has full ...

    • WINDOWS 7 FILE SHARING REGISTRY SETTINGS (FIXES SRV 2017 SERVER ERROR)

      The following is a copy of an article from Alan Lamielle. It solves file sharing issues for Scrap Dragon on Windows 7 Pro. We should make sure that all Windows 7 Pro SD servers have the settings described in this article: mount error(12): Cannot ...

    • Scrap Dragon Xtreme Help File

      Click this link for the Interactive Scrap Dragon Xtreme Help File