November 7, 2007 at 10:28 am
Hello,
First, I'm no SQL expert... I have a SQL 2000 install that has gone bad ... it was recommended to un-install and re-install SQL 2000. I want to take this opportunity to upgrade or do a fresh install of SQL 2005... How can I accomplish this? I have all the data in the folders of the original install... I have backups of the folders as well to a date before the problems began....
Can un-install SQL 2000, install SQL 2005 put on latest SP and then "import" or "rebuild" the orignal SQL 2000 database?
Please help...
Thank You
Dirk
November 7, 2007 at 10:37 am
What do you mean 'gone bad'?
It's possible to do an in-place upgrade of a SQL2000 instance. It's also possible to attach SQL 2000 databases to a 2005 instance and they will upgrade (as long as they're not corrupt). It's also possible to restore a backup of a SQL 2000 database on a SQL 2005 instance and they will upgrade (again, as long as they're not corrupt in some way).
Do you have SQL backups from before things went bad?
Paul Randal
CEO, SQLskills.com: Check out SQLskills online training!
Blog:www.SQLskills.com/blogs/paul Twitter: @PaulRandal
SQL MVP, Microsoft RD, Contributing Editor of TechNet Magazine
Author of DBCC CHECKDB/repair (and other Storage Engine) code of SQL Server 2005
November 7, 2007 at 10:51 am
As Paul already wrote, the big question is what is wrong with your current server.
If you uninstall SQL 2000 and makea new 2005 install, you need to recreate all logins, jobs, alerts, operators etc. because these are stored in system databases and you can't restore those to 2005.
With an upgrade all this will be taken care of during the upgrade.
MS has a pretty extensive document about how to upgrade and what you have to take care off. http://www.microsoft.com/downloads/details.aspx?FamilyID=3d5e96d9-0074-46c4-bd4f-c3eb2abf4b66&DisplayLang=en
Markus
[font="Verdana"]Markus Bohse[/font]
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply