Regularly shrink the SQL database to reduce log storage pressure_PHP tutorial

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

www.bkjia.comtruehttp: //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...