Results 1 to 2 of 2
  1. #1
    Join Date
    May 2003

    Question Unanswered: Does SQL Server 2000 have any method or sp to copy files from other machine?

    If I use a workstation connected to a SQL Server 2000, can I remote the SQL Server to copy some external files (mdf & ldf) from other network machine.

    I need to do it by programming, under condition:
    SQL Server name is provided.
    Network paths of mdf & ldf files are provided.

  2. #2
    Join Date
    Aug 2002
    You need to detach them using SP_DETACH_DB and copy them to the new location. Also refer to books online for RESTORE ... WITH MOVE topic for more information.
    --Satya SKJ
    Microsoft SQL Server MVP

Posting Permissions

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