Discover Top Posts Tagged with #useful sql command

Useful SQL command to reduce the size of the database

今日想和大家分享一個幾有用的TSQL Command, 去Release 返一些SQL Server 佔用的空間 Transaction log 和Database file

-- select database USE Production; -- Change the recovery mode to SIMPLE, to clear the transaction log ALTER DATABASE Production SET RECOVERY SIMPLE ; -- shrink database to release space DBCC SHRINKDATABASE (Production, 1);