Post reply

Newbie needs help using Enterprise Manager and MS SQL 2000 Desktop Engine (MDSE)

  • February 18, 2004 at 6:53 pm

    #82001

    I am new to SQL. I have a website on one box and an SQL db on another. I want to learn how to use Enterprise Manager to transfer (copy? import?) my data from the SQL server to my desktop computer. I want to use MSDE 2000 instead of SQL 2000. My host does not recommend the use of DTS Packages. Can anyone tell me how I can do this?

  • February 19, 2004 at 11:51 am

    #494761

    You can use the Export/Import Wizard (but this is really just DTS) SO if you don't want to do this then try either:

    a.  Backup you database (copy the backup file to your desktop and restore)  Use Enterprise Manager if you are new to this.

     

    b.  If nonoe is using the database.  Detach it using Enterprise Manage and copy the MDF and LDF files to your desktop and the use Enterprise Manager to attach the database.

    Francis

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

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