Home > Backend Development > PHP Tutorial > Regularly shrink the SQL database to reduce log storage pressure_PHP tutorial

Regularly shrink the SQL database to reduce log storage pressure_PHP tutorial

WBOY
Release: 2016-07-13 17:03:29
Original
783 people have browsed it

Generally speaking, the shrinkage of SQL database cannot reduce the size of database to a great extent. Its main function is to shrink the log size. This operation should be performed regularly to prevent the database log from becoming too large. 1. Set the database mode to simple mode: Open SQL Enterprise Manager, click Microsoft SQL Server in the root directory of the console-->SQL Server group--> Double-click to open your server--> Double-click to open the database directory-->Select your database name (such as
ForumDatabase Forum)--> Then right-click and select Properties-->Select Options--> Select "Simple" in the fault recovery mode, and then press OK to save 2. Right-click on the current database to see the shrink database in all tasks. Generally, the default settings do not need to be adjusted, just click OK. 3. After shrinking the database, it is recommended to reset your database properties to the standard mode. The operation method is the same as the first point, because the log is often an important basis for restoring the database under some abnormal circumstances.

Original address: http://www.phpchina.com/?13542/action_viewspace_itemid_2928.html



http://www.bkjia.com/PHPjc/630963.html

truehttp: //www.bkjia.com/PHPjc/630963.htmlTechArticleGenerally, shrinking a SQL database cannot reduce the size of the database to a great extent. Its main function is to shrink the database. Log size, this should be done regularly to avoid database logs becoming too large...
source:php.cn
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Popular Tutorials
More>
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template