September 17th, 2001, 11:29 AM
|
|
Contributing User
|
|
Join Date: Dec 2002
Posts: 14,575
Time spent in forums: < 1 sec
Reputation Power: 22
|
|
|
Clean a transaction log file
Originally posted by : Alex (AlexLut@aol.com)Hello,I need to clear a log file in SQL Server 2000. I know that I can shrink and remove any unused space and etc. My problem is that a log file has a lot of old transactions and I would like to not only shrink the file but also clean it. Let's say my file right now is 20mb and I want to make it back to 2mb. Thank you in advance.
|
ASP Free Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
