SQL Server 2000 Clean log fine Graphics tutorial _mssql

SQL Server Clean Log Fine tutorial

SQL Server 2000 database log is too large!
How do I clean up the log for SQL Server 2000?
How do I compress a SQL Server 2000 log?
How do I make SQL Server 2000 log smaller?

According to the small part of the know, there are many ways to sum up, there are 3 categories:

1, click a few mouse, with SQL Server 2000 management tools in the Enterprise Manager can be realized, later detailed;
2, with SQL statements, in the SQL Server 2000 Management Tool Query Analyzer can be implemented, this method senior people like to use;
3, with third-party tools to achieve, the principle, I think it should be implemented with SQL statements, this method is good, easy to use, online no lack of boutique tools, later introduced a.

First, now we describe in detail how to use Enterprise Manager to clean up the log of SQL 2000:

1, open Enterprise Manager, right click on the database to be processed--"attributes-" option-"Failure to restore, select" Simple "-" OK. Figure:

2, right-click the database to be processed--all tasks--"Shrink database-" Nothing moves, the default first is 0%, the other two is unchecked, Dot OK-If your previous database log file is greater than 1M then look now, is not only 1 m.

3, after the operation--"in the first step, the" failure to restore ", selected" complete ", the legendary SQL Server 2000 has the automatic restore function, That is, if the illegal shutdown factors such as data loss can be automatically rolled back, and can use the program to implement the rollback, so it is best to let the failure to restore is "complete."

4, which enables the SQL Server 2000 database log to be too large! How to manage, clear, become small, compress it "in the purge, become small, compressed, as to how to manage, I look to do it, I generally will only use these, and then in-depth study of the words I will write up."


Two, now we introduce the use of Third-party SQL Server log Cleanup tool to clean up the log, simple and efficient, recommended this method.
I like to use SQL Server log Cleanup expert v3.5 to implement this feature. The interface is as follows:

database typically lists the database names of the entire server, and you need to choose which one to manage for your account, I'm here db_ Iszip account can manage is iszip, select Good, click "Clear Log" button, then SQL Server 2000 log is cleared up, at this time you go to the server to see your database log Occupy space is only 1 m.
This software is very useful, you ask me where to download the address? Well, here:
SQL Server Log cleanup expert v3.5 Download Address:
http://www.jb51.net/softs/35630.html