Post reply

LDF file from Hell

  • July 23, 2003 at 12:54 pm

    #64840

    Hello,

    I've got a Transaction Log that just won't give in. I've tried all kinds of backups and truncate, shrink and even detached the database and remove the ldf file and attempted to reattach. Typically, this worns me and asks me if I want to create a new transaction log. But not with this guy, it just won't go away.

    Any ideas?

    Thanks

    Amir

  • July 23, 2003 at 1:01 pm

    #466643

    Are you trying to recreate log file for your database? Which version of SQL Server you run? Have to try to detach it and attach it with sp_attach_single_file_db? How many log files the database has?

  • July 23, 2003 at 1:06 pm

    #466644

    Create a test table in your DB and do some dummy transactions in a loop and then backup the log with no log and then take a Full backup

    Shas3

  • July 23, 2003 at 3:16 pm

    #466659

    "I've got a Transaction Log that just won't give in"

    Question: Give in to size, multiple ldf files

  • July 24, 2003 at 6:41 am

    #466774

    Check to see if your recovery model is set to full. If so, set it to simple and try shrinking. Full recovery has given me problems with log size at many points in the past.

  • July 24, 2003 at 9:11 am

    #466848

    You could always just stop SQL Server, delete the LDF then restart SQL Server.. before you do so, make sure your initial size setting isn't huge, or you'll be right back where you started.

    If that's too scary, just try it with renaming the LDF. SQL Server will create a new logfile with the initial settings..

    However... I have a funny feeling that if there are uncomitted transactions your db may go suspect.


    -Ken

Viewing 6 posts - 1 through 5 (of 5 total)

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