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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Log file size

Author  Topic 

nitin1353
Constraint Violating Yak Guru

381 Posts

Posted - 2006-08-24 : 13:13:50
Gurus
I have a log file of 15gb.and when in enterprise manager i check out in shrink db and click on files i see that current file size is 15618 mb and used is 15607 mb..How do i shrink this file..it will not shrink beyond 15607 mb.Plz guide

Regards
Nitin

nr
SQLTeam MVY

12543 Posts

Posted - 2006-08-24 : 13:24:10
see
http://www.nigelrivett.net/SQLAdmin/TransactionLogFileGrows_1.html


==========================================
Cursors are useful if you don't know sql.
DTS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page
   

- Advertisement -