October 15, 2009 at 8:06 am
I'm looking @ upgrading our 774 GB DB from 2000 to 2008. There won't be any new hardware so I won't be able to upgrade a copy on a different server.
Any suggestions will be appreciated!
Thanks, Tina
October 15, 2009 at 8:12 am
HI Jonest
Any suggestions will be appreciated!
What suggestions do you expect to hear from us?
October 15, 2009 at 8:15 am
My suggestion would be to do a lot of testing before you try this in production, if you do not have another server you can always install a virtual machine and use this for testing.
October 15, 2009 at 8:19 am
What's the question?
Gail Shaw
Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability
October 15, 2009 at 8:21 am
Tina,
download the upgrade advisor and check out the 2000 installation.
Backout is an uninstall\reinstall SQL2000 so make sure you are in a position to do that. backup up ALL databases before you start. Extract details on your installation (sp_configure, keep last errorlog). I would recommend taking flat file copies of the SQL2000 system database files before you start to simplify any backout to SQL2000.
If you have DTS install the backward compatibility tools as well so you can still edit DTS packages until you can migrate them to SSIS (search technet for SQL 2008 feature pack)
allow plenty of time, you will need to reindex the database to get good performance after the upgrade.
---------------------------------------------------------------------
October 15, 2009 at 8:22 am
AAAaaaaaaaaaaaaaaaaaaaargh!
---------------------------------------------------------------------
October 15, 2009 at 8:30 am
george sibbald-364359 (10/15/2009)
AAAaaaaaaaaaaaaaaaaaaaargh!
Was that the answer, or did you have a caffeine free moment.
--------------------------------------------------------------------------------------
[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]
October 15, 2009 at 8:32 am
Thank you, you've given me a lot to check into.
October 15, 2009 at 8:40 am
I was hoping to find someone who has upgraded a large DB from 2000 to 2008 & wouldn't mind sharing any helpful tips.
Sorry for the vagueness of my post.
October 15, 2009 at 8:47 am
Silverfox (10/15/2009)
george sibbald-364359 (10/15/2009)
AAAaaaaaaaaaaaaaaaaaaaargh!Was that the answer, or did you have a caffeine free moment.
Gail Knows. She keeps pre-posting me. I think she's playing with my mind. 🙂
---------------------------------------------------------------------
Viewing 10 posts - 1 through 9 (of 9 total)
You must be logged in to reply to this topic. Login to reply