sql数据库压缩方案（SQL database compression scheme）.docVIP

sql数据库压缩方案（SQL database compression scheme） SQL database compression scheme Compress database solution 1. Clear logs using BACKUP LOG database WITH NO_LOG Changing the fault recovery model in the database properties to simple can greatly slow down the rate of log growth. If you restore the model to a simple, this does not support the restore of time points, but the log file will be small, if the data is more important, it is recommended to restore the database model is complete BACKUP LOG database WITH named NO_LOG, will not cut the activity log, without reducing the physical log file size, but the logical log will be reduced, after shrinking the database will not delete the log to release the virtual space, will not damage the data. If the log is truncated and the database is compressed, you cant restore it directly with a recent full library backup. It is recommended that you backup the database immediately, just in case. 2, SQL server running, can delete the primary database transaction log file? The steps are as follows: (1) detach database business manager - Database - right-click on the database where you want to delete the log - all Task separating database (2) and then delete the log file (3) and then add the database Enterprise Manager - Database - right-click database - all tasks - additional databases are added only at this time. MDF is fine. 3, compressed SQL database and log detailed methods SQL Server 2000 tutorial - compressed database in use after a period of time, often there will be a lot of free space in the database due to delete the data, then you need to reduce the allocation to the database and transaction log files on disk space, in order to avoid wasting disk space. When there is no data in the database, the database file can directly modify the properties of the space change, but when there is data in the database, it will destroy the data in the database, so need to use the compression method to reduce spatial database. You can choose the