Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Upgradation of sql server Expand / Collapse
Author
Message
Posted Thursday, June 20, 2013 6:30 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Monday, September 29, 2014 10:47 AM
Points: 68, Visits: 178
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 ?
Post #1465640
Posted Thursday, June 20, 2013 7:06 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 31,168, Visits: 15,612
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.







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1465670
Posted Thursday, June 20, 2013 10:33 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Tuesday, September 9, 2014 9:02 PM
Points: 33, Visits: 157
Direct upgradation of sql 200 to 2008 or 2008 R2 is not pssible, first you have to upgare to 2005 and then to 2008.
Post #1466034
Posted Thursday, June 20, 2013 11:46 PM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Today @ 4:56 PM
Points: 31,168, Visits: 15,612
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







Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1466049
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse