June 20, 2013 at 6:30 am
is there any issues to upgrade sql server from 2000 to 2008 ?
and what is the better way to upgrade from 2000 to 2008 ?
and can we restore system databases of sql server 2000 to 2008 and system databse of sql 2005 to 2008 ?
June 20, 2013 at 7:06 am
Run the upgrade advisor.
There's no simple/easy way to answer this. There can be issues, or the upgrade may go fine.
I'd recommend side by side upgrade rather than in place, but that's me.
June 20, 2013 at 10:33 pm
Direct upgradation of sql 200 to 2008 or 2008 R2 is not pssible, first you have to upgare to 2005 and then to 2008.
June 20, 2013 at 11:46 pm
That's not true.
First, upgradation isn't an English word. It's merely an upgrade, or upgrading to SQL Server 2008.
Second, upgrades from SQL Server 2000 or SQL Server 2008 are supported to SQL Server 2008
http://msdn.microsoft.com/en-us/library/ms143393(v=sql.100).aspx
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply