-
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!!
-
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
-
Thanks monte96,
This is the answer I've been looking for!!
