November 1, 2008 at 10:14 pm
Hi everybody, my question is the next.
I have a Database Server SQL 2000 Cluster on Windows 2000 Server and i have to migrate to SQL 2005 Cluster on Win 2003.
In this case, i have the SQL 2005 Cluster Server in a couple of servers news in win2003 Enterprise and i need to migrate all data of my old cluster on windows 2000 SQL DB to the new cluster servers.
Exist a guide step by step to do this ???
Can you help me with information about this ???
Thanks a lot and my best regards to all
Sorry for my english is not to good
November 2, 2008 at 1:32 am
Hi,
First of all, download and use the SQL Server 2005 Upgrade Advisor:
You then have 3 options to choose between:
1. Use Copy Database Wizard
You can find instructions here: http://msdn.microsoft.com/en-us/library/ms188664(SQL.90).aspx or here:
http://msdn.microsoft.com/en-us/library/ms190775.aspx
2. Detach and Reattach the database
Instructions: http://msdn.microsoft.com/en-us/library/ms189625(SQL.90).aspx
3. Backup and Restore
Instructions: http://msdn.microsoft.com/en-us/library/ms190436.aspx
Personally, I prefer 3. Backup and Restore but other people might have other preferences.
With either method, you need to script all your jobs and logins if you want to transfer them (there is a Transfer Logins task in SSIS you can use as well) because you cannot copy/attach/restore any of the system databases.
After the upgrade, you might want to change the compatibility level (see sp_dbcmptlevel in Books Online) and you must run sp_updatestats in every database.
HTH!
/Elisabeth
elisabeth@sqlserverland.com
MCITP | MCT
http://sqlblog.com/blogs/elisabeth_redei/
http://linkedin.com/in/elisabethredei
November 4, 2008 at 4:48 pm
Elisabeth, thanks very much.
This information its very good for a rookie like me, i choose the option 3, backup and restore and his work very fine !!!!.
Again, thanks, i send you a kiss and thanks a lot
GS
Viewing 3 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply