Database Size Control

I can now see that build 20 is out which is an excellent piece of work on the part of the HC team. Keep it up.

One of its enhancement is the Database size control for MSSQL server. How does that exactly work.

Here are the instructions to use database size feature in Hosting Controller:

Configuration at host level:

- Enable database size feature at Server Manager--->Global Settings( Database Server)
- Define database size for each reseller at Hosting Plans--->Resource Propertiese(SQL Server Databases Properties)

Plan creation at Reseller level:

- Create a new plan and set some value of following resources and sell this plan to webadmin.

Maximun Log File (LDF) Size
Maximun Data File (MDF) Size



________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-341-1419

There should be an option to shrink the database and the log file since the applications stop working if the database mdf or the ldf files are full.

An ICANN Accredited Domain name Registrar - OwnRegistrar.com
| Shared Hosting | Reseller hosting | Dedicated server | - QualiSpace.com
Premium AntiSpam / AntiVirus gateway - SpamTermino.com
Signup as a reseller and get domains only for $6.49

If we remove database log file does it effect db ?

Nitaish, this feature will be available in HC8 coming releases.

________________________
HC Support Team
support@hostingcontroller.com
http://hostingcontroller.com
+1-213-995-3037

quote:

---

Originally posted by patrick
[br]If we remove database log file does it effect db ?

---

In SQL 2000. you could remove the ldf file by detaching the database and while attaching the mdf file of the database, it created a new ldf file. It was fairly simple, but no longer in SQL 2005. In SQL 2005, removing the ldf file does not allow to create a new ldf file while attaching the db and it fails. Shrinking is the only option, but even that is not fool proof as the ldf file cannot be shrunk if there is no free space available within it.


An ICANN Accredited Domain name Registrar - OwnRegistrar.com
| Shared Hosting | Reseller hosting | Dedicated server | - QualiSpace.com
Premium AntiSpam / AntiVirus gateway - SpamTermino.com
Signup as a reseller and get domains only for $6.49

HC Support

Nitaish, this feature will be available in HC8 coming releases.

________________________
HC Support Team

I really agree with this feature.

We have already provided these feature in HC8 build2 version. You can check it in Tool :: Database Manager. check action against any database.