• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 521
  • Last Modified:

MSSQL 2000 32bit Standard backup being restored to MSSQL 2008 64bit Web Edition

Hi All,
I want to backup a MSSQL 2000 32bit Standard database and restore it to a MSSQL2008 64 bit Web Edition - is there anything I need to do, as it is moving from a 32bit to 64bit, and different versions of the database.
Thanks
Jamie
0
Jamie
Asked:
Jamie
  • 3
  • 2
3 Solutions
 
AanvikCommented:
Direct backup-restore should be fine. No need for any extra steps.
0
 
Aneesh RetnakaranDatabase AdministratorCommented:
Some of the features on 2000 wont work on 2008, you should run SQL Server Upgrade Advisor on the 2000 machine before restoring the backup.
Once you backup, you have to apply the changes recommended by Upgrade advisor and after that change the db compatability to 100 in order to get all the benefits of sql 2008
0
 
JamieAuthor Commented:
Hi aneeshattingal,

Unfortunately I will not be able to run SQL Server Upgrade Advisor on the 2000 machine before restoring the backup, as it is a shared server, and I will have to request the hosting company does the backup for me and sends me the backup files - which I will then use to restore on 2008.

Is there any other resource I can use to get the SQL Server Upgrade Advisor information I need?

thanks
JamWales
0
Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

 
Aneesh RetnakaranDatabase AdministratorCommented:
what you can do is, you can generate the entire db script and try running it on the 2008 machine, that will also show some incopatability messages
0
 
JamieAuthor Commented:
Hi aneeshattingal,
How do I generate an entire db script from a shared hosting server?
thanks
JamWales
0
 
JamieAuthor Commented:
Thanks for your help.
0

Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now