Transfer/Backup SQL7 to SQL2000

Posted on 2005-05-16
Last Modified: 2011-09-20
hi! i have got two machine, one is running SQL7 and the other SQL2000. i would like to ask how could i transfer/backup data between them. Both of them is not network together, so the only way for me is using a pen drive to transfer the DB to and from the two machine, but i need details instructions of howto

thank you,
Question by:aboka
    LVL 14

    Assisted Solution

    You can take a backup of the DB from SQL7 and restore it on SQL 2000.
    Another option is detach and attach the DB.

    Take a look at these two articles..
    LVL 3

    Accepted Solution

    Right Click on the Database u want to take the backup, then in all tasks u will get "BACK UP DATABASE"option. back up the Database.
    Similarly for Restoring the Database.

    U can detach andattach the DB also, but some times u need to stop the SQL services to perform that operation.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Why You Should Analyze Threat Actor TTPs

    After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

    Suggested Solutions

    The steps for moving the system databases to a new location are documented in the following technical article: However sometimes after the moving process is finished, though SQL i…
    Performance is the key factor for any successful data integration project, knowing the type of transformation that you’re using is the first step on optimizing the SSIS flow performance, by utilizing the correct transformation or the design alternat…
    Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
    Via a live example, show how to shrink a transaction log file down to a reasonable size.

    761 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    6 Experts available now in Live!

    Get 1:1 Help Now