Emergency - MS SQL help needed nowwwww

[downhiller80]

Right, I need to copy a database from a server running MSSQL7 to a laptop running MSSQL7 personal edition.

You can't DTS to a personal edition, which is a *real* pain in the arse.

I tried stopping the service on the server and copying the MDF and the LDF files across but that doesn't seem to have worked - Enterprise Manager sees a corrupt database, with zero tables.

Any advice?

I need to do this SUPER ASAP.

cheers

- seb

 

[bunker]

Copying the mdf and ldf should have worked.

The only other thing I can think for you to try is do a backup of the DB and try restoring it on the laptop.