Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
macsterling
Yak Posting Veteran
56 Posts |
 Posted - 2008-08-06 : 14:35:52
|
| I am running a number of SQL scripts many times a day against my database, and now my 130GB drive is full. I have looked all over the drive for log files or something else that is taking up space. I can't find anything specific. I am deleting what files I can find, and have to do disk cleanups frequently. I get about four to five more runs. The data base is not that outrageously large, but every time I turn around it is full. Any ideas? |
|
|
acollins74
Yak Posting Veteran
82 Posts |
Posted - 2008-08-06 : 14:42:11
|
| What recovery model is your database in. |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-08-06 : 14:49:07
|
| Either change your recovery model to SIMPLE or start backing up your transaction log on a scheduled basis. If you don't require point in time recovery, then I'd use SIMPLE recovery model.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/Subscribe to my blog |
|
|
|
macsterling
Yak Posting Veteran
56 Posts |
Posted - 2008-08-06 : 16:02:20
|
| BINGO! I don't remember how it was set up - I am looking now to see what it is and how to change if from full to simple. I recreate the database every time I start (that is part of what I am doing - writing a conversion process) so I don't need info after it is run.Later.... It was on full - thanks !!! |
|
|
|
|
|
|
filling up my hard drive