Results 1 to 6 of 6
  1. #1
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40

    Unanswered: Copying SQL, mdf file / Please help

    I have a SQL db on my server in internet
    the server and my DB is online
    I want to copy mdf file to my computer via FTP but I get an error
    that file is in use and I can`t copy it

    I wanted to know is there any way that i copy information in that MDF fle
    to another DB on my computer

    Its very important please help me

    thanks all

  2. #2
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    I don`t have permission to remote access or change any thing in Enterprise Manager

  3. #3
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    I'd do a SQL Server Backup, and then FTP the resulting backup (aka DUMP) file. You can use that to rebuild a copy of the database on another machine.

    -PatP

  4. #4
    Join Date
    Jul 2003
    Location
    San Antonio, TX
    Posts
    3,662
    You can do sp_detach+ftp_sp_attach to do the same, except a lot faster.
    "The data in a record depends on the Key to the record, the Whole Key, and
    nothing but the Key, so help me Codd."

  5. #5
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    Quote Originally Posted by rdjabarov
    You can do sp_detach+ftp_sp_attach to do the same, except a lot faster.
    Hi buddy
    thanks but can you tell me how can i use that code
    and where I can use it


    thanks alot

  6. #6
    Join Date
    May 2004
    Location
    Dubai
    Posts
    40
    I just have permission to use FTP now

Posting Permissions

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