Results 1 to 2 of 2
  1. #1
    Join Date
    Jul 2004
    Posts
    214

    Unanswered: cannot copy files

    I copied a database using backup and restore from Sql server 2000 to Sql server 2005. I noticed the data(mdf) and log(ldf) files did not copy. when I try to do a copy and past it gives me an error: cannot copy lof: it is being used by another person or program. Close all programs and try again. Does this mean I have to stop both servers to copy between them? Please help.

  2. #2
    Join Date
    May 2004
    Location
    Seattle
    Posts
    1,313
    just to clarify, did you successfully restore the db on 2005? if so, then I assure you the mdf and ldf are there. maybe they are not where you think they should be however.

    to find out where they are, do this:

    use MyDatabase
    exec sp_helpfile

Posting Permissions

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