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.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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment