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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-04-05 : 07:59:19
|
| Paul writes "I am new to SQL SERVER, I would like to truncate transactional log space, when I do this, will the transactional file shrinks.Thanks" |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-04-05 : 08:39:05
|
| Truncating the log removes committed transaction records, BUT it will not shrink the file size. The DBCC SHRINKFILE command WILL shrink the log for you. It is documented in Books Online, and also check here:http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14474http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=14591 |
 |
|
|
|
|
|
Truncating Transactional log