September 2, 2009 at 12:10 pm
We have A SQL Server 2000 Server with Several Instances and a seperate SQL Server 2005 Server built out with the same instances and I have been migrated databases from 2000 to 2005 by scripting out the logins on the 2000 server and recreating them on the 2005 server and then doing a backup and restore (2000 to 2005)
So far this has worked great.
is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005? I thought that a migration of sorts took place when you did the restore? can anyone explain?
September 2, 2009 at 12:44 pm
As you stated, the database conversion takes place during and after the restore to the 2005 server. It will be in version 8 compatibility mode. There is no need to change that unless you need to take advantage of certain features exclusive to SQL Server 2005.
The probability of survival is inversely proportional to the angle of arrival.
September 2, 2009 at 1:03 pm
Thank you for the clarification and information : )
September 3, 2009 at 12:36 am
If you are not going to take advantages of SQL 2005 specific features why upgrade ?
"Keep Trying"
September 3, 2009 at 2:17 am
Chirag (9/3/2009)
If you are not going to take advantages of SQL 2005 specific features why upgrade ?
simple, mainstream support for sql 2000 has expired, so unless you pay for extended support from microsoft, the EOL (end of life) support has ended for SQL 2000
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 3, 2009 at 2:30 am
Jpotucek (9/2/2009)
We have A SQL Server 2000 Server with Several Instances and a seperate SQL Server 2005 Server built out with the same instances and I have been migrated databases from 2000 to 2005 by scripting out the logins on the 2000 server and recreating them on the 2005 server and then doing a backup and restore (2000 to 2005)
So far this has worked great.
is there ever a need to actually do an upgrade as opposed to restoring a 2000 database to 2005? I thought that a migration of sorts took place when you did the restore? can anyone explain?
There is a need when you are installing SQL 2005 on the same server which is currently your SQL 2000 box. If you have new hardware then doing it the way you have done it makes the most sense to me and is the way i did it as well 🙂
September 4, 2009 at 2:13 am
Silverfox (9/3/2009)
Chirag (9/3/2009)
If you are not going to take advantages of SQL 2005 specific features why upgrade ?simple, mainstream support for sql 2000 has expired, so unless you pay for extended support from microsoft, the EOL (end of life) support has ended for SQL 2000
That slipped from my mind... just curious how much would extended support cost?
"Keep Trying"
September 4, 2009 at 2:19 am
Chirag (9/4/2009)
Silverfox (9/3/2009)
Chirag (9/3/2009)
If you are not going to take advantages of SQL 2005 specific features why upgrade ?simple, mainstream support for sql 2000 has expired, so unless you pay for extended support from microsoft, the EOL (end of life) support has ended for SQL 2000
That slipped from my mind... just curious how much would extended support cost?
Totally depends on the size of the estate and the relationship that the company has with micorosoft.
--------------------------------------------------------------------------------------
[highlight]Recommended Articles on How to help us help you and[/highlight]
[highlight]solve commonly asked questions[/highlight]
Forum Etiquette: How to post data/code on a forum to get the best help by Jeff Moden[/url]
Managing Transaction Logs by Gail Shaw[/url]
How to post Performance problems by Gail Shaw[/url]
Help, my database is corrupt. Now what? by Gail Shaw[/url]
September 4, 2009 at 6:05 am
We are upgrading for a couple of reasons: Support has ended for SQL Server 2000. Our SQL Server 2005 Instance is on a shiny new and more powerfull Server : )
All of the Databases on the SQL Server 2000 are back-end for out of the box applications - nothing homegrown where any development is taking place - so migrating the databases with backup and restore sounds like it will work out just fine.
The few Instances where we have databases as a backend for home-grown or otherwise customized apps, I will be doing an upgrade in place so that we WILL be able to take advantage of the 2005 features and enhancements. Thanks again for all of your thoughts.
September 6, 2009 at 1:31 pm
Update statistics might be an idea too
I'm a DBA.
I'm not paid to solve problems. I'm paid to prevent them.
Viewing 11 posts - 1 through 10 (of 10 total)
You must be logged in to reply to this topic. Login to reply