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 - 2002-01-08 : 10:16:58
|
| Bunty writes "Sir,I have two servers 1)SQL 7,0 and 2)SQL2000If I try to take a backup under SQL7.0 and restoring in SQL2000.It is possible. My problem is If I take a backup in SQL2000 and try torestore in SQL7.0 I am not able restore the database.Please suggest me, How to go about it.My email id is : e_bunty@yahoo.com" |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2002-01-08 : 11:39:08
|
| AFAIK, backups from version 2000 can not be restored on version 7. The only thing you can do to transfer the database over is to create a script of all your database objects in SQL2k (be sure to script SQL7-compatible features only), run that script on your SQL7 and then DTS the data from 2000 into 7. |
 |
|
|
|
|
|
Database restore problem