The method of shrinking sqlserver Database
/ * /
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
