压缩SQL Server数据库日记文件(国外英文资料).docVIP

收缩SQL Server数据库日志文件(国外英文资料) How does the LDF file shrink the SQL Server database log LDF file Summary: in fact, two instructions can be completed BACKUP the LOG DateBaseName WITH TRUNCATE_ONLY DBCC ShrinkDatabase (DateBaseName) The best backup log, which can be recovered by logging, is the following log processing method: Generally is not recommended to do two steps 4, 6, 4 step is not safe, may damage the database or data loss, step 6 if log reach limit, after the database processing will fail, can be restored after clear the log. All of the library names below refer to the library name of the database you are dealing with 1. Clear the log The DUMP TRANSACTION library name WITH NO_LOG Stop the transaction log: BACKUP LOG library name WITH NO_LOG Shrink the database file (the database file will not shrink if it is not compressed) Enterprise manager - right-click on the database you want to compress - all tasks - shrink the database - contract files - select the log file - in the way choice in contraction to XXM, here will give you a minimum to allow contraction M number, enter this number directly, sure. - select data file - in the way choice in contraction to XXM, here will give you a minimum to allow contraction M number, enter this number directly, sure. You can also use SQL statements - shrink the database DBCC SHRINKDATABASE (library) The file number 1 is the file number, which can be queried by the statement: select * from sysfiles DBCC SHRINKFILE (1) To minimize log files (if it is SQL 7.0, this step will only be done in the query analyzer) Separate database: the server -- the database -- right-click -- the database B. Delete the LOG file on my computer C. additional database. Enterprise manager - server - database - right-click - attach the database This method will generate a new LOG size of more than 500 K Or use the code: The following sample separation, pubs, and then attach a file of pubs to current server. A. separate: EXEC sp_detach_db @dbname = libr