Transfer/Backup SQL7 to SQL2000

Posted on 2005-05-16
Medium Priority
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

puranik_p earned 200 total points
ID: 14008822
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..

Accepted Solution

r_a_j_e_s_h earned 300 total points
ID: 14008858
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.


Featured Post

Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
This month, Experts Exchange sat down with resident SQL expert, Jim Horn, for an in-depth look into the makings of a successful career in SQL.
This video shows, step by step, how to configure Oracle Heterogeneous Services via the Generic Gateway Agent in order to make a connection from an Oracle session and access a remote SQL Server database table.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

850 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