February 23, 2012 at 5:03 pm
I need to migrate number of sql server databases from 2000SP4 server to another server with sql server version 2005SP3. Can I backup all databases from 2000SP4 and restore them to 2005SP3 directly (or detach from 2000sp4 and atach to 2005sp3) ?
or I have to upgrade 2000sp4 to 2005sp3 in the same source server and then backup/restore to anotehr server with 2005sp3?
Just want to confirm if the version of 2000sp4 is compatible with 2005sp3.
Thanks in advance!
February 23, 2012 at 5:12 pm
You can backup and restore, no problem. Note that it's a one-way operation, once the DB is restored to 2005, you cannot move it back to SQL 2000.
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
February 24, 2012 at 7:29 am
Hi GilaMonster,
Thanks for your info. I appreciate your help.
February 24, 2012 at 9:15 am
I have anotehr question continue with data transfer (or database clone) from 2000sp4 to 2005sp3:
I have big list of databases (more than 30 databases) need to be cloned from 2000sp4 to 2005sp3.
If it is only for one database, we can use SQl server EM to backup database from source server and restore it on the target server using SQL Server EM.
For big number of databases, such as my case over 30 DBs, I believe it must have a script to handle DB backup process in the source server and a script to handle restoration in the target server.
Is this correct?
If yes, can some experts help on how to get these scritps?
If not, can you please let me know if there is any easy way to handle multiple database clone to another server without using manual process?
Thanks for any of your inputs!
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply