Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Import a .mdf (SQL7) in SQL Server 2000
Message
 
To
15/06/2001 07:55:55
Michael Levy
Cincinnati, Ohio, United States
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Re: Import a .mdf (SQL7) in SQL Server 2000
Miscellaneous
Thread ID:
00519806
Message ID:
00520225
Views:
15
I need the DataBase in SQL 2000. The SQL 7 is unistall on that pc.

So I need to restore this database right in SQL Server 2000.
Does the Copy Wizard will work?

>You can take the backup/restore approach. You can detach the database, make a copy and then reattach it to both servers (this only works 7 -> 2000). You can also use the Copy Database Wizard.
>
>-Mike
Jean-René Roy President of http://www.softdesign.qc.ca/
President of http://www.DevTeach.com and http://www.SQLTeach.com
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform