Originally posted by mpnetwork I have a friend who would like to setup a web hosting account with Microsoft SQL Server 2000/2003. They also need a fair bit of storage, 10GB. Does anyone have any recommendations for a good web host?
Is he dealing with 10GBs worth of databases? If so, my only advice to your friend is to take the necessary precautions in ensuring that his hosting provider can service databases of that size and magnitude. That is quite a lot of data and with respect to that, I personally would look into something beyond the normal hosting accounts that are available with many hosts. It would be a shame to lose that amount of data.
Small Business Web Hosting with DOT45
24/7/365 Technical Support; Windows Shared Environment; ColdFusion MX, ASP.NET, PHP, MS SQL, MySQL, Online Store Software, SiteBuilder, Secure Webmail via IlohaMail
Have your friend re-check his storage requirements. We have migrated several users where the problem is the log files are not truncated in MS SQL and that is where the large storage requirements are coming from.
A good configeration backups databases daily and truncates the log files with every backup.
█ Link On Us .com
█ H-Sphere Windows & Linux Hosting - Since 1998
█ One Wilshire Corridor, Los Angeles, Calif
Originally posted by Yash-JH If even 9 out ot 10GB of that database was log files.. that database is best on a dedicated SQL server.. Such big log files can only indicate to me very heavy database activity...
A 1 GB MS SQL DB is quite large and probably isnt a good fit for a shared server - let alone one that may even be larger...
A VPS "may" do it - however, you could probably assume that a DB of this size has alot of simultaneous connections - which may end up exceeding the resource allocations of a typical VPS.