Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2003-01-13 : 08:36:51
|
| Mala writes "Hi ,I want to know is it possible to attach/restore file/backupfile created in SQL 6/SQL 7 to SQL 2000. When i try to attach or restore it is giving error. Please let me know how can I covercome this problem." |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2003-01-13 : 08:40:31
|
| Not from a backup file. You can only attach data or log files from SQL 7.0 (or 2000) to a SQL 2000 server. Anything earlier than SQL 7.0 would have to be exported from a running server of that version and then imported to the new. Or you could have that old server upgraded using the Upgrade Wizard during SQL 2000 installation, and it will convert the data (only 6.5 can go to 2000, if you have 6.0 you'd need to install SQL 7.0 to upgrade it) |
 |
|
|
|
|
|
Attach Database