# Method steps
1. Change the execution of SQL statement to Simple Mode.
Step 2 shrink the database
3. Execute the SQL statement and change back to "full mode"
# # Step 1: Change the execution of SQL statement to "simple mode"
Use [master]
go to
Change the database? SlowXWebDB (change it to the name of the database that needs to be shrunk) sets RECOVERY SIMPLE with NO_WAIT.
go to
ALTER DATABASE SlowXWebDB SET RECOVERY SIMPLE-Change to simple mode.
go to
# # Step 2: Perform database operation.
Screenshots and operations of related interfaces
Suppose:
Database name: SlowXWebDB
Log file name: SlowXWebDB_Log
The database log file is too large and needs to be cleaned.
** 1. Select the database and right-click Task-Shrink-File? Note: The file type is selected as Log * *
2. Select the size to be reduced, as shown in the figure below, and the minimum size is 0MB. I actually measured it, and the minimum can only be 1MB, but it is already very satisfactory. Haha * *
3. Click "Confirm", and the log file of several tens of gigabytes is thinned down with a whoosh. * * * See the effect of cleaning up database log files.
# # Step 3: Change the execution of SQL statement to "full mode"
Use [master]
go to
ALTER DATABASE SlowXWebDB SET RECOVERY FULL WITH NO_WAIT.
go to
ALTER DATABASE datebaseName sets the restore full restore to full mode.
go to
= = Finally, don't forget to test whether the database can be used normally = =
Web page link