Transfer database to MSDE ->MSDE

  • Hello there I want to know how to transfer a database in one computer to another in Microsoft SQL Server Desktop Engine (MSDE is this possible ?

  • MSDE comes with QA tool OSQL.EXE and use it

    1. You can backup database in MSDE A and restore it into MSDE B.

    2. Shutdown MSDE and copy MDF and LDF files from MSDE A into MSDE B and run sp_attach_db.

    Edited by - Allen_Cui on 03/31/2003 07:33:04 AM

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply