July 21, 2009 at 5:20 pm
In the near future we will be taking backups of 32 bit sql 2000 databases and restoring them in 64 bit 2005 sql. Are there any gotchas?
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 21, 2009 at 10:50 pm
An SQL2k/32 backup restored to an SQL2k5/x64 server is exactly the process we have used to migrate some of our databases, including some of our major systems. We have not experienced any gotchas with that part of the process, except things that would have tripped us up no matter which way we did the conversion, such as new reserved words.
As always though, the most important thing is testing under the new platform. Most SQL statements perform better under SQL2k5, but we've had a few (less than 1 in a thousand) that have performed worse and needing tuning or rewriting. You also need to look at things such as the compatibility level.
July 22, 2009 at 9:15 am
Yes, compatibilty is important. We will also be taking 64 bit 2005 backups and restoring them in 32 bit 2000. Careful testing will be needed.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 22, 2009 at 9:18 am
fizzleme (7/22/2009)
Yes, compatibilty is important. We will also be taking 64 bit 2005 backups and restoring them in 32 bit 2000. Careful testing will be needed.
You wont be able to restore a 2005 Backup into 2000, no matter what version you have. You can only go up eg. 2000 --> 2005
July 22, 2009 at 9:34 am
Well shucks! I guess I'll have to upgrade our sql 2000 server to 2005.
Yahoo! More $$.
When the snows fall and the white winds blow,The lone wolf dies but the pack survives.
Once you've accepted your flaws, no one can use them against you.
July 22, 2009 at 9:43 am
fizzleme (7/22/2009)
Well shucks! I guess I'll have to upgrade our sql 2000 server to 2005.Yahoo! More $$.
If you are buying Licenses you may want to look at 2008 and take advantages of the new features
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply