Web Hosting Resource

If you receive an email from support@pipeten.co.uk or .com with the title “Warning (Approaching resource limit)” it means that you are approaching or exceeding some of the inclusive resources on your hosting package. Explanations of what these resources are and what each warning means can be found below:

1. Mailbox Disk Quota
2. Traffic Quota
3. Databases: MySQL Quota or MSSQL Quota
4. Linux Disk Quota or Windows Disk Quota or Reseller Disk Quota

If still in doubt, please don’t hesitate to contact support through the usual methods.

When you reach approach or exceed the default size of your hosting packages inclusive database quota/storage you will receive an email from support@pipeten.co.uk or .com to the primary account contact with the subject “Warning (Approaching resource limit)”. This post provides further information on what can be done to remove ‘MySQL Quota’ or ‘MsSQL Quota’ warnings.

(more…)

Closed.
(more…)

When connecting to an MS Sql 2005 Server using MS SQL Server Management Studio 2008 you may come across an error “Failed to retrieve data for this request (Microsoft.SqlServer.Management.sdk.sfc)”. This in turn will prevent you from being able to connect to your database. This is a known issue with Microsoft and occurs when either a database is in offline mode or when SQL Server Management Studio cannot correctly read one or more databases. Therefore, certain properties of a database cannot be retrieved. However there is a work around for this if you follow the instructions below:

1. Close the error message.
2. Press F7 to open the Object Explorer Details pane.
3. Right-click the column headers, and make sure that only the following columns are selected:
   *Name
   *Date Created
   *Policy Health
   *Owner
4. Right click the Databases node, and then click Refresh.

For more information the please view the Microsoft knowledge base.

http://support.microsoft.com/default.aspx?scid=kb;EN-US;956179

Support for the old MS SQL Manager that used to be available via the online control panel has been removed.  This was because of the lack of functionality, security risks and general poor performance that the third party package was offering.

It has been replaced with another online MS SQL administration tool called mylittleadmin which is more secure and provides a lot more functionality.  It also ties in with mylittlebackup which is also available as a tool to backup your MS SQL databases.  Users on the dmssql.pipeten.co.uk server can backup their databases using dmylittlebackup.

As always you can also manage your MS SQL database remotely by using a client on your local machine such as SQL Server Management Studio or Aqua Data Studio.

Pipe Ten are please to announce a beta release of MyLittleAdmin, the web based administration tool for SQL servers. (more…)

Due to popular request Pipe Ten have now launched their exciting new SQL Server 2005 backup facility using MyLlttleBackup. All customers that have databases on Pipe Ten’s MSSQL server can now log in to the new online backup facility to create, download and restore full backup’s of their databases directly through their web browser.

Sheffield/mssql.pipeten.co.uk use http://mylittlebackup.pipeten.co.uk/

Derby/dmssql.pipeten.co.uk use http://dmylittlebackup.pipeten.co.uk/

Since our last Dublin update we’ve had a few users having issues with their old OSCommerce installs. Below you’ll find the most common problem and fix.
The problem: Error Message – 1054 – Unknown column ‘p.products_id’ in ‘on clause’

The fix: Download the instructions helpfully provided by ozstar.

An easy way to publish your database to Pipe Tens database server is to use the Database Publishing Wizard.

(more…)