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 |
|
kotsas
Yak Posting Veteran
65 Posts |
 Posted - 2002-06-10 : 05:45:48
|
| I do shrink of transaction log and after that truncate. Log get his initial size. After that I enlarge the log but after truncating log file again get his initial size. What is problem? How I can solve it? |
|
|
dataphile
Yak Posting Veteran
71 Posts |
Posted - 2002-06-10 : 06:43:14
|
| Is there a problem?If you want to reserve disk space for the transaction log, change the initial size in the database properties and prevent it from growing automatically. |
 |
|
|
|
|
|
Shrink transaction log