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 |
|
acko
Yak Posting Veteran
52 Posts |
 Posted - 2004-03-22 : 09:37:39
|
| Hi I have a transactional log that size is 7286.12mb and space used is 548.42mb. When i shrink log to 1000mb i get something like this:Current size: 7286.12mb and space used: 623.53mb.I think that current size should be 1000mb.Why current size still 7286.12mb.thanksalex |
|
|
samsekar
Constraint Violating Yak Guru
437 Posts |
Posted - 2004-03-22 : 10:17:07
|
| Have you specified Truncateonly option ??.. If you specify NoTruncate the freed size of the log file will not be released to the operating system. Use TruncateOnly Option. Check BOL on topic DBCC ShrinkFile for more details. - Sekar |
 |
|
|
raymondpeacock
Constraint Violating Yak Guru
367 Posts |
Posted - 2004-03-22 : 10:22:28
|
| Also useful to look at would be "Shrinking the Transaction Log" and "Truncating the Transaction Log", both also in BOLRaymond |
|
|
|
|
|
|
Log Shrink