SQL Database Copy

[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

 

[Jon Fincher]

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.

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.