restore database from SQL2k to SQL 7 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

restore database from SQL2k to SQL 7

hi how to restore sql2000 database from backup file (only have backup file) to sql 7.0
database?? thanks
yamaha
Not possible to restore SQL 2K to SQL 7.
Only the way is to use DTS wizard for data transfer and script the other objects and apply on 7 server.
_________
Satya SKJ
Moderator
SQL-Server-Performance.Com

]]>