Clear log file in SQL Server 2000

zhaozj2021-02-11  151

When using SQL Server, log files in the database are getting bigger and bigger, and you need to delete it.

I first separate this database, right-click on the database -> All tasks -> After separating the database, you can delete the log file, and the data can be backed up. After that, you can add that database in all tasks, SQL Server will prompt the log file does not exist, ask you if you want to create a new one, choose it, this, the log file is emptied.

This method is just a few minutes, but in these minutes, you can't access this database. I think it is only suitable for small applications. For large systems, you have to find other methods.

转载请注明原文地址:https://www.9cbs.com/read-5517.html

New Post(0)