[Rock]

Hi Trevor,
Apologies for replying late, we were busy with few administrative tasks being carried out on few of our servers.. Let me answer your questions thoroughly:

Originally Posted by TrevorL

0. "Most of our clients have failed to attach the database from the .MDF file in their application directory" - it sounds like this could still be worth a try. Please let me know the physical location of my website hosting so I can give it a go, and I'll report back.

The complete physical path of your website hosting on the server is : "D:\Inetpub\vhosts\domain.com\httpdocs\"
You can replace the domain.com with any of your domains hosted on the server.

Originally Posted by TrevorL

1. "Connect the SQL Server database remotely and create all the tables in it." - assuming you mean do this with Management Studio or similar in place of the Plesk WebAdmin route - I'll try this and report back.

Yes, this has to be done from the local machine using SQL Server Enterprise Manager, which is supplied freely with the MSSQL 2000 Connectivity Tools.

Originally Posted by TrevorL

2. "Create a backup up of your database on your local machine and upload the .bak file on the server and ask us to restore it for you." Thanks for the offer. However, the db will get upgraded a number of times over the next few weeks and months. Does this mean we would have to do this manual upload every time?

Yes, you'd need to backup your DB, compress it into a Zip file & upload it onto the server, notify us by placing a ticket or through live chat, we'd uncompress it & restore it into your database properly..

Originally Posted by TrevorL

I've just tried this (and I remember now I did try it over the weekend). I use SQL Server Management Studio Express and connect to mysql.preservedtanks.com and login in to my database using my SQL Server user id and password (i.e. the same as I used in Plesk to create the database). This shows me a list of databases called DURHAM\Databases; there are about a 100 shown so I imagine they are all the client databases on our shared server - but I only have permission to see the details in my databases. Within my ones I can see the available tables etc. However, if I Execute a query against my database to create new tables it just generates errors and no new tables are created.

Edit: I've looked into this in some more detail - some simple commands (e.g. CREATE TABLE) execute successfully, but the full script required to recreate my databases fails. I'm thinking it may be a SQL Server version problem. I'm using SQL Server 2005 Express at my end. Could it be that SQL Server 2000 or some other version is running on the server?

It's looking like this 'Method 1.' could work, but I'd still appreciate some feedback on the questions in my post above.

Yes, you are hosted on a server which has MSSQL 2000 Enterprise Edition installed on it. Hence you'd need to connect to the database server using Microsoft Query Analyzer [isqlw.exe] utility & execute/run the complete scripts from within it into your database...

PS: Opening a support ticket with windows@eukhost.com would provide faster responses/solutions..