Post reply

Transaction protocol

  • October 31, 2005 at 7:33 am

    #110734

    Hi all, we have an SQL-Server 2000 database that takes 7GB disc space. The transaction protocol takes additional 7GB disc space. All we daily do with that database is to delete all rows from each table and then insert new ones. How can I turn off the transaction protocol? What ist that protokol in my case useful for? Regards Ralf

  • October 31, 2005 at 7:49 am

    #601295

    If you are deleting all rows from the table you need to use the truncate table statement rather than the delete from table statement as the truncate table statement is a non logged operation, each row deleted is logged when you use delete from statement, so your transaction log will have thousands on delete transactions in the log.

    Hope this helps.

    Regards

    Carl 

  • October 31, 2005 at 8:37 am

    #601336

    Hi Carl, thanks for Your help.

    Regards

    Ralf

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

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