How can I reduce my Database size Buy Truncating and Shrinking it?
For each transaction, the database create a log file, by over time, the high volume of database space will be occupied. But you can apply through the instructions bellow to delete the log files.
Depending on the type of service you are using, one of the following methods can be used for entering to SQL Web Manager:
If you are using Website Panel as your hosting panel (2008 services):
Type cp.yourdomainname then enter your username and password to login to your WSP control panel. Click on database after that SQL Server 2008.In the current page click on browse database that is in front of your database name.
If you are using Helm as your hosting panel (2003 services):
Type cp.yourdomainname then enter your username and password to login to your Helm control panel. Click in domains then your domain’s name. In the current page select Database option and then click on the database name. You can now use the connection information to the database server’s address. (i.e. sql2.yourdomain/sqladmin)
1- Type the address in the address bar of your browser.
2- After entering the username and password, you can enter "SQL Web Manager".
3- In the left pane click the "logs truncate" button.
4- Click on the "truncate" button in the page loaded bellow.
5- This time, click on the Shrink button.
6- After that, in target percentage put 0 then click the shrink button.
After completion you can see the database’s volume on the current page (see the bottom of the left pane)