We recently updated our
Terms and Conditions for TechRepublic Premium.
By clicking continue, you agree to these updated terms.
Invalid email/username and password combination supplied.
An email has been sent to you with instructions on how to reset your password.
Welcome to TechRepublic!
All fields are required. Username must be unique. Password must be a minimum of 6 characters and have any 3 of the 4 items: a number (0 through 9), a special character (such as !, $, #, %), an uppercase character (A through Z) or a lowercase (a through z) character (no spaces).
Due to scheduled maintenance, the ability to log in to your account and make purchases will be disabled December 1 - 2.
You should be able to tell SQL Server to do that automatically. Open SQL Server Manager and go to the database you want to compact. Right-click that database and open “properties”. Click on “Options” and then make sure the Check-box “automatically compact” is set (it may be a different wording, depending on the language).
If that doesn’t work for you, you could consider creating a new database and then restoring a dump.
You can shrink/compact a database by using SQL Enterprise manager and right clicking on the database that you would like to shrink/compact and choosing All Task, Shrink Database. If you prefer T-SQL you can use the command dbcc shrinkdatabase followed by the database name.