A method for emptying LOG files in SQL Server 2000

Server
When you use SQL Server, the log file in the database grows larger and needs to be deleted.

I first separate this database, on the database point right key-> All tasks-> separate the database, after separation, you can delete the Log file, but also can be backup data. After that, you can add the database to the additional database in all Tasks, SQL Server will prompt log file does not exist, ask if you want to create a new one, the election is on the line, so that the log file is emptied.

This method only takes a few minutes, but in these few minutes, you can't access the database, I think only for small applications, for large systems to find other ways.