Is it possible to restore SQL2000 backup to SQL2005? Or I have to restore the DB to SQL2000 and then upgrade it to SQL2005?
Can someone provide me ways to upgrade SQL2000 DB to SQL2005?
Thanks,
Hiten
Simply restore it on the SQL 2k5 server. Backups of 2k are compatible with SQL2k5 (but not vice versa). You have to be aware that the internal (meta) structure of the database is upgraded during the restore process and therefore can′t be backuped and restored on the SQL2k after the upgrade.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
|||Is this possible on SQL 2005 Express too? Or I need to have SQL server 2005 ?|||That also valid for SQL Server 2k5 Express.HTH, Jens K. Suessmeyer.
http://www.sqlserver2005.de
No comments:
Post a Comment