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

    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
    Location
    Scotland
    Posts
    1,578
    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
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

Posting Permissions

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