MS SQL is good, but after a while, the database becomes large and the actual amount of data is small. Are generally caused by the database log! The database log grows up to hundreds of M.
The online MSSQL virtual host price is also expensive, to want to not allow the database to exceed the capacity, had to compress the database log, or delete the database log.
Now let me introduce you to a method
1. Open Enterprise Manager
2, open the database to be processed
3. Click menu > Tools >sql Query Analyzer
4, enter in the input window:
Copy Code code as follows:
DUMP TRANSACTION [database name] with NO_LOG
BACKUP LOG [database name] with NO_LOG
DBCC shrinkdatabase ([database name])
Click Execute! In this way, the database is working successfully.
The method inside the program:
Compress database logs
--1. Empty log
EXEC (' DUMP TRANSACTION [' + @dbname + '] with no_log ')
--2. Truncate the transaction log:
EXEC (' BACKUP LOG [' + @dbname + '] with no_log ')
--3. Shrink the database file (if not compressed, the database file will not be reduced
EXEC (' DBCC shrinkdatabase ([' + @dbname + ']) ')