Results 1 to 3 of 3

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

  1. #1

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2000
    Posts
    343

    Angry

    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!!




  2. #2
    Frenzied Member monte96's Avatar
    Join Date
    Sep 2000
    Location
    Somewhere in AZ
    Posts
    1,379
    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

    oOOo--oOOo
    __/\/\onte96
    oOOo--oOOo
    Senior Programmer/Analyst
    MCP
    monte96_@hotmail.com
    monte96@vbgarage.com


    Your results may vary.. some restrictions may apply.. pricing and participation may vary.. not available in all states.. professional driver closed course..quantities limited..

  3. #3

    Thread Starter
    Hyperactive Member
    Join Date
    Aug 2000
    Posts
    343

    Talking

    Thanks monte96,

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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width