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 |
|
cplusplus
Aged Yak Warrior
567 Posts |
 Posted - 2007-05-04 : 10:19:28
|
| Our database .mdf file and log file both are growing fast since we have have a function in the front end to upload documents as blob object to database table. because of that function it seems the whole database is growing rapidly. can we shrink the log file. is it ok or will it corrupt the database file .mdfplease help thank you very much for the information. |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2007-05-04 : 10:40:44
|
| you can backup the transaction log and shrink the file, but it will grow again...one option is not to save blobs to a database_______________________________________________Causing trouble since 1980blog: http://weblogs.sqlteam.com/mladenp |
 |
|
|
Kristen
Test
22859 Posts |
|
|
|
|
|
Database Log file is growing tremendously