Post reply

change db from multiple logs to single log

  • October 4, 2005 at 9:26 am

    #89562

    I am moving a SQL 7 db to SQL 2k via Restore with move. This process creates and upgrades the db in situ but what I really want is to have a db with a single log file (it currently has two). How do I go about achieving this?

  • October 4, 2005 at 10:27 am

    #594920

    alter database your_db remove file the logical log file to remove

    If it gives errors, you need to truncate the log first.

     

  • October 5, 2005 at 12:35 am

    #595065

    Or, just take the SQL v7 file (just the .MDF), copy it to your new server and use

    sp_attach_single_file_db to attach it and SQL will create a new log file for you.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply