April 2, 2008 at 3:17 am
Hi
i have to copy our old master db from 2000 to a new sql 2005 server. i have tried it with dts but with no success.
is there a best practise method for my problem.
thanks
mfg
Christian
April 2, 2008 at 3:32 am
sry, can someone move this thread to the sql2005 forum
April 3, 2008 at 3:05 am
Don't even try this!
None of the system databases can be moved from SQL Server 2000 to SQL Server 2005. You need to script out all user objects from yuor SQL Server 2000 system databases and script them into SQL Server 2005.
The only exception is where you do an upgrade in place. In this case, the install process will upgrade the system objects in the system databases to the SQL Server 2005 standard. However, the upgrade in place does not always work, and if it fails you will have to uninstall SQL Server and do a new SQL Server install.
Most people who have upgraded from SQL Server 2000 to SQL Serve 2005 recommend that you do not do an upgrade in place, as it is too risky.
Original author: https://github.com/SQL-FineBuild/Common/wiki/ 1-click install and best practice configuration of SQL Server 2019, 2017 2016, 2014, 2012, 2008 R2, 2008 and 2005.
When I give food to the poor they call me a saint. When I ask why they are poor they call me a communist - Archbishop Hélder Câmara
April 3, 2008 at 3:07 am
I fixed it...
You cannot restore the Sql Server 2000 system database backup in Sql Server 2005 server only user databases can be restored. To restore the system databases you need to have the same build and edition of Sql Server.
the way i did it -> http://support.microsoft.com/kb/246133
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply