Log and data files growing out of control 1

[tpmcafee]

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.

 

[JayKusch]

You could first of all set your database to Simple mode. I would then run a Shrink Database on the DB(s) in question.

Thanks

J. Kusch

 

[JayKusch]

To put the DB in Simple mode, right-click the database in Enterprise Manager and choose Properties. From there go to Options and on that screen set model to Simple.


To shrink your DB ... Right-click on the DB and choose "All Task" ... "Shrink Database"

Thanks

J. Kusch

 

[tpmcafee]

Worked! You are a genious and are very valuable to this site