SQL SERVER UPLOAD - NO-ONE HAS BEEN ABLE TO HELP!!

[turfbult]

Hello,

I am having endless troubles in finding out how to upload my sql db to my host. All they say is that it is just a matter of ftp'ing it to them, but WHAT do I ftp. I know with access it's a simple matter of ftp'ing the *.mdf files, but what extension(??) does sql server db's have.

What are the steps to do this??

Once my db is uploaded - how do I maintain it (add record, delete records etc remotely)

No-one has been able to help me so far!!

Please!!!!!! Any suggestions or books or websites... ANYTHING!!

[monte96]

You need to find out from your provider whether they require a backup of your database to restore (a full backup is my prefered method of moving it..) or just the MDF file. If you check your MSSQL7/DATA folder you'll find your database files (*.MDF). Make sure your service is stopped and you can copy the files out of there and send it to where-ever you need to. Then someone with Admin role needs to use the system stored proc:

sp_attach_single_file_db @DBName, @FullPathtoDatafile

[turfbult]

Thanks monte96,

This is the answer I've been looking for!!