Log and Data File growing out of control

  • I have a database that I do a lot of transactions with. I delete all of the data daily. We also backup our servers daily. When there is no data in the database, how come my database_log.ldf and database_data.mdf are so huge? These two files are 13 megs and are killing my backup. I don't need them. How do I get my dabase to quit writing these files? I tried deleting them but it removed all of the tables from my database. Please help. These files are growing out of control.

  • Please do not cross post !!!  Your question has been answered here: http://www.sqlservercentral.com/forums/shwmessage.aspx?messageid=112334

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

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