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 ««12

Upgrade SQL Server 2000 to SQL Server 2008 Expand / Collapse
Author
Message
Posted Friday, July 12, 2013 9:45 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Wednesday, July 9, 2014 7:10 AM
Points: 58, Visits: 537
This is a poorly written information request. I realized that with some of the responses. I did specify a side-by-side scenario initially but botched from there. Even in my last response - did it again. I do try to be careful however this came up way too short. My apologies to everyone.

Very simply - I want to move SQL Server 2000 databases to a SQL Server 2008 (side by side).
Not only consolidate the servers to one but upgrade the environment. Some of the SQL 2000
instances are on Windows 2000 - there's no support for the OS.

Copy SQL Server 2000 backup to the SQL Server 2008 instance. That'll do it.

My apologies to everyone again.
Post #1473119
Posted Friday, July 12, 2013 12:02 PM


SSC-Dedicated

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

Group: Administrators
Last Login: Today @ 4:02 PM
Points: 33,062, Visits: 15,176
no need to apologize and glad you got it figured out.

you've got the right solution. Move backups, restore.

Also, script out logins (sp_helprevlogin) and move those. Watch out for linked servers, replication, packages, things that might need to move from the instance level.







Follow me on Twitter: @way0utwest

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

Add to briefcase ««12

Permissions Expand / Collapse