SQL Database Copy

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Anybody know how to copy the SQL database from one computer to another. I already have the SQL Server installed on both computers, I just need to know what database files to copy over.

Thanks,
Nathan
 
Anybody know how to copy the SQL database from one computer to
another. I already have the SQL Server installed on both computers, I
just need to know what database files to copy over.
Click to expand...

Look in the \Windows Embedded Data folder for the MDF file you need.
You'll need to detach the DB in SQL Administrator, then copy off the MDF
file in that folder (MantisSQLDB.MDF). Don't forget to re-attach the
MDF to use it again.

BTW, you can ignore the LDF - it's a log file, it will get recreated if
necessary.
 
Back
Top