marrowyung
asked on
move system database from SQL server 2005 SP2, RTM to SQL server 2005 SP4
Dear all,
Can we move system database from SQL server 2005 SP2, RTM to SQL server 2005 SP4?
or different built can't do it anyway?
DBA100.
Can we move system database from SQL server 2005 SP2, RTM to SQL server 2005 SP4?
or different built can't do it anyway?
DBA100.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
that one, http://blogs.technet.com/b/beatrice/archive/2009/02/10/best-practices-for-installing-sql-server-service-packs-hotfixes-cumulative-updates.aspx , doesn't provide much informaton.
But we can jump from SQL server 2005 SP2 to SP4, right? we done before that SQL server 2005 RTM can be upgrade to SP2.
But we can jump from SQL server 2005 SP2 to SP4, right? we done before that SQL server 2005 RTM can be upgrade to SP2.
ASKER
sorry I should add one more like, can we upgrade from SQL server 2005 RTM to SP4 also ?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
No step by step - it is just another SP, but you can read the release notes : http://social.technet.microsoft.com/wiki/contents/articles/1727.microsoft-sql-server-2005-sp4-release-notes.aspx
Also, dont you have a cluster ? Then your probably want to follow : http://technet.microsoft.com/en-us/library/bb497962(v=sql.90).aspx
Also, dont you have a cluster ? Then your probably want to follow : http://technet.microsoft.com/en-us/library/bb497962(v=sql.90).aspx
ASKER
Also we can simply upgrade SQL server 2005 RTM and SP2 to SP4 directly, right?
so I think the SP4 can also deploy on the SQL server 2005 Enterprise cluster on top of Windows 2008 R2 enterprise cluster, right?
so I think the SP4 can also deploy on the SQL server 2005 Enterprise cluster on top of Windows 2008 R2 enterprise cluster, right?
Yes, it can, but there can be a small problem sometimes if only doing SP3 (per the other thread), see : http://support.microsoft.com/kb/973993
ASKER
yeah. so do SP4. thanks.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER