Hi to anybody who can help on this,
I am facing problems with a Database originally built under SQL 2000 while trying to restore it from SQL 2005. Is there any incompatibility on the data bases? Otherwise, is there any change I should keep in mind and/or do before migrating to SQL 2005?
Thank you
You can restore a sql2000 backup on sql2005 without any issue.
You can NOT restore a sql2005 backup on sql2000.
System databases from sql2000 can not be restored to sql2005. Best to use an in-place upgrade performed during installation of sql2005 to handle that.
Hope that helps.
No comments:
Post a Comment