How to restore/install the .mdf and .ldf files? 1

[CInman]

Is there a way to take the actual database files in their non-backed-up format (.mdf and .ldf files) and somehow "restore" or "install" them onto another SQL Server? Versions are 6.5, 7.0 and 2000 and any help or suggestions would be very much appreciated.

Thanks in anticipation.

 

[RickCole]

Yes you can on SQL 7.0 and 2000 by using the stored procedures sp_detach_db and sp_attach_db. Check BOL for the topic “Attaching and Detaching Databases” for more details.

Unfortunately this does not work on 6.5. You could upgrade the 6.5 databases to 7.0 via the upgrade wizard and then detach and attach as required.

Rick.

 

[CInman]

Rick, thanks loads - that's exactly what I needed to know - you're a star

Rgds,

C.