SQL Server 2000 log cleanup excellent graphic tutorial

SQL Server 2000Log cleanup tutorial

SQL Server 2000 database logs are too large!
How can I clean up SQL Server 2000 logs?
How to compress SQL Server 2000 logs?
How can I reduce the Log Size of SQL Server 2000?

As far as xiaobian knows, there are many methods. To sum up, there are three categories:

1. Click a few clicks and use the Enterprise Manager in the SQL Server 2000 management tool. You will be able to explain it later;
2. SQL statements can be used in the query Analyzer of SQL Server 2000 management tools. This method is preferred by senior personnel;
3. Use a third-party tool for implementation. I think it should be implemented using SQL statements. This method is good and easy to use. There are no shortage of excellent tools on the Internet. I will introduce it later.

I. Here we will describe in detail how to use the Enterprise Manager to clear SQL 2000 logs:

1. Open the Enterprise Manager, right-click the database to be processed, choose Properties> Options> fault recovery, and choose simple> OK.

2. Right-click the database to be processed -- all tasks -- contract the database -- and there will be no changes. The first task is 0% by default, and the other two are not selected, click "OK". If your database log file is larger than 1 MB, check whether it is only 1 MB.

3. After the operation, take the first step and select "completely" for "fault recovery". It is said that SQL Server 2000 has the Automatic Restoration function, it is said that if data is lost due to factors such as illegal shutdown, data can be automatically rolled back. In addition, you can use a program to perform Operation rollback, so it is best to make fault recovery "completely ".

4. In this way, "SQL Server 2000 database log is too large! How to manage, clear, shrink, and compress the "delete, shrink, and compress". As for how to manage it, I will do it myself. I usually only use this, I will write it down for further research.


2. Now we will introduce how to use a third-party SQL Server log cleanup tool to clean up logs. This method is simple, easy to use, and efficient. We recommend this method.
I like to use SqlServer log clearing expert v3.5 to implement this function. The interface is as follows:

The database usually lists the database names of the entire server. You need to select the one that can be managed by your account. Here, the DB_iszip account can manage iszip, click the "Clear log" button, and the SQL Server 2000 logs are cleared. At this time, you can go to the Server to check that your database logs occupy only 1 MB of space.
This software is really quite useful. Where do you ask me? Well, here:
SqlServerLog clearing expertV3.5:
Http://www.jb51.net/softs/35630.html