Click here to monitor SSC
SQLServerCentral is supported by Redgate
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
Posted Friday, July 12, 2013 9:45 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Monday, December 14, 2015 8:49 AM
Points: 77, Visits: 689
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



Group: Administrators
Last Login: Yesterday @ 8:38 AM
Points: 34,366, Visits: 18,586
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