Post reply

emptying the log file and move log to other log files

  • June 16, 2009 at 9:31 am

    #135208

    I have 3 log files and need to remove couple of log files from one of my DB in sql server 2005 and keep only one log file , so moving all the logs from these two log files to other 3rd log file which i want to keep ,what are the steps i need to take care for this action?

    Thanks for your time!!

  • June 17, 2009 at 2:57 am

    #1010704

    I'm assuming you mean transaction logs.

    You can het rid off transaction logs by using dbcc shrink to shrink it down to zero, then using the dbcc shrink emptyfile option. Then alter the database using the remove file option.

    In my experience, though, it is not possible to remove the transaction log that was created first.

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

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