Shulou(Shulou.com)06/01 Report--

/ * /

1. Right-click-Properties-options-simple Mode

two。 Right-click-Task-shrink-File

3. Right-task-shrink-database

/ * /

Transaction logs are often enlarged in SQL Server. In addition to setting the database to "auto shrink", you can also use the following SQL command to quickly clear the transaction log in the database, as follows:

-step 1: clear the log

DUMP TRANSACTION

Databasename

WITH

NO_LOG

Step 2: truncate the transaction log

BACKUP LOG

Databasename

WITH

NO_LOG

Step 3: shrink the database

DBCC SHRINKDATABASE (databasename)

There are several points that need to be explained:

1. The above SQL commands need to be executed sequentially

two。 Executing the above command is usually much faster than directly using the "shrink" command in the right-click menu

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.