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 |
|
kaus
Posting Yak Master
179 Posts |
 Posted - 2001-06-06 : 11:37:10
|
| Ive got dataspace:140 mb used 360 mb freetransaction log:16 mb used 470 mb freewhen I go to shrink db or truncate transaction log cant get database any smaller. Are there any other methods I can use to shrink the database ??The entire database is truncated, and rebuilt occasionally (export from oracle)-- is this why transaction logs are so big ??Thanks |
|
|
|
|
|
shrink database, truncate transaction log