Post reply

How to delete a part of log file

  • December 7, 2004 at 5:48 am

    #60266

    Hi,

    I want to copy a database from one server to another server(my computer). I use detach and attach method to copy the database. The problem is the log file of the database is too large that I can not attach to the another server. So I want to delete a part of the logfile so that I can attach the database.

    Are there any methods to delete a part of the log file?

    Regards 

    - Loi -

  • December 7, 2004 at 6:02 am

    #532810

    Presumably sp_attach_single_file_db.

    --
    Frank Kalis
    Microsoft SQL Server MVP
    Webmaster: http://www.insidesql.org/blogs
    My blog: http://www.insidesql.org/blogs/frankkalis/[/url]

  • December 7, 2004 at 7:07 am

    #532823

    Thanks, Frank. It worked

    Regards

    - Loi -

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

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