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 |
|
pelegk2
Aged Yak Warrior
723 Posts |
 Posted - 2007-04-05 : 12:47:11
|
i have log file of 600 mb and i want to make it 0MB or something like thati tried to do :DBCC SHRINKFILE(Storage1_Log, 1)BACKUP LOG Storage1 WITH TRUNCATE_ONLY but when i check the folder there is no change!what can i do ?thnaks i nadvancepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2007-04-05 : 13:16:56
|
| BACKUP LOG Storage1 WITH TRUNCATE_ONLYDBCC SHRINKFILE(Storage1_Log, 2)also, can't shrink smaller than original size.what recovery model is db in? if full or bulk-logged, u should be doing tran log backups, and if u arent or dont need tran log backups, then u should flip db to simple. |
 |
|
|
jayp369
Starting Member
26 Posts |
Posted - 2007-04-05 : 13:17:24
|
| what recovery model is it on?Jay |
|
|
|
pelegk2
Aged Yak Warrior
723 Posts |
Posted - 2007-04-08 : 02:06:26
|
| its on simplei think it isnt working beacuse of the minimum size of the log defined on the 31985.how do decrease the minimum size to the minimum that is possible?Thanks in advnacrepelegIsrael -the best place to live in aftr heaven 9but no one wan't to go there so fast -:) |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-09 : 16:04:46
|
| Detach the db and reattach it with data file only, sql will create a small empty log file. |
|
|
|
|
|
|
cleaning a log file