Post reply

emptyfile transaction log files

  • July 2, 2007 at 10:00 am

    #177320

    Hi

     

    How can shrinkfile using empty files. Iam trying to shrink the transaction logs and create new ones Is this possible?

     

    one of my coworkers said that I can create a new log file in the sqldata directory and shrinkfile emptyfile the current transaction log. Is this possible?

  • July 2, 2007 at 10:14 am

    #716583

    If I understand, you want to create a new log file and then remove the old one from your database? AFAIK this isn't possible. You can "move" the log to a new place. You can detach the old files and attach them and move the file to a new location.

    Is this what you need?

  • July 2, 2007 at 10:46 am

    #716597

    Hi,

        If u want to delete a file from a filgroup,u need to ensure that the file is empty.http://msdn2.microsoft.com/en-us/library/aa258824(SQL.80).aspx

    The DBCC command will move all the datas to another file in the same filegroup before emptying it and then u can remove it if neccessary...cool

     

    [font="Verdana"]- Deepak[/font]

  • July 2, 2007 at 12:48 pm

    #716637

    Steve

     

    Thanks for your suggestion, I know I was able to do this with the mdf file but I guess we will not be able to do it using the ldf files.

     

    Thanks

    Rajini

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

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