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 - 2000-12-11 : 17:52:17
|
chris writes "I administer a SQL Server 7.0 DB running on WINNT 4.0 w/ sp 6 at work and have watched our transaction files grow extremely large. Right now my MDF file is 980,600K and the LDF
file is 5,223,040K. Any time I need to do a backup and restore it takes the process quite a while to complete. Is there any way for me to commit all the transactions and shrink the size of the ldf file down to where it is more manageable?" |
|
|
|
|
|
commiting transactions