December 4, 2005 at 8:45 am
Our business is using a vendor system designed on SQL 2000. But we plan to upgrade our platform throughout business to SQL 2005 for specific internal reasons. Our evaluation on using SQL 2005 was success to continue running the system. However the vendor can support only on SQL 2000. Is there anyway we can backup from SQL 2005 and restore on SQL 2000 and vice versa.
Your thoughts and comments are much appreciated.
Thanks!
December 5, 2005 at 8:14 am
Copy Of Sql2000 backup to Sql2005 and Restore as 2005 db will work fine.
In Output of restore, you will find message- conversion of 2000 db [8.0] to 9
When you think of vice- versa
taking copy of sql2005 backup to sql2000 and try to restore that as sql2000 database, it will not work and will end up with following message.
Server: Msg 3205, Level 16, State 2, Line 1
Too many backup devices specified for backup or restore; only 64 are allowed.
Server: Msg 3013, Level 16, State 1, Line 1
RESTORE DATABASE is terminating abnormally.
I am working on this issue and am in process of finding some work around or solution from other experts and will keep you posted when I will be able to suggest you some fix to the problem.
Kindest Regards,
Sameer Raval [Sql Server DBA]
Geico Insurance
RavalSameer@hotmail.com
December 5, 2005 at 9:17 am
Most software is backwards compatible. Forward compatible does not make sense. There may be compelling reasons to upgrade to SQL 2005 however if the software vendor does not support it, well then you should not do it. Sure, you may have tested it and things are fine under SQL 2005, but most (if not all vendors) 'certify' their products for specific platforms (one big reason is support). So you by 'upgrading' to SQL 2005 you may inadvertantly void your support contract. My advice is to leave well enough alone - at least until your software vendor says you can upgrade. If you choose another course than I'd but stock in a company that manufactures a good 'pain reliever' becuase you'll be using lts of it.
RegardsRudy KomacsarSenior Database Administrator"Ave Caesar! - Morituri te salutamus."
December 5, 2005 at 2:19 pm
I would recommend keeping at least one SQL 2000 server to support your clients who are still on that platform. Some people may not upgrade for quite a while and it would benefit you to be able to sell services for both platforms.
December 5, 2005 at 9:44 pm
Thanks everyone for your comments!!!
Sameer... hope you'll crack the code and let us know...
Thanks again!!!
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply