• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 620
  • Last Modified:

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.
0
marrowyung
Asked:
marrowyung
3 Solutions
 
marrowyungSenior Technical architecture (Data)Author Commented:
Also we can simply upgrade SQL server 2005 RTM and SP2 to SP4 directly, right? any step-by-step guide?
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
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.
0
Cloud Class® Course: Certified Penetration Testing

This CPTE Certified Penetration Testing Engineer course covers everything you need to know about becoming a Certified Penetration Testing Engineer. Career Path: Professional roles include Ethical Hackers, Security Consultants, System Administrators, and Chief Security Officers.

 
marrowyungSenior Technical architecture (Data)Author Commented:
sorry I should add one more like, can we upgrade from SQL server 2005 RTM to SP4 also ?
0
 
Mark WillsTopic AdvisorCommented:
You need to apply SP4 to your existing system.

No, you cannot restore any system database to a version other than the exact version it was running on at the time of backup.

Please see : http://msdn.microsoft.com/en-us/library/ms190190(v=sql.90).aspx and scroll down to the restore, you will note the comments in the box :
System databases can be restored only from backups that are created on the version of SQL Server that the server instance is currently running. For example, to restore a system database on a server instance that is running on SQL Server 2005 SP1, you must use a database backup that was created after the server instance was upgraded to SQL Server 2005 SP1.
0
 
Mark WillsTopic AdvisorCommented:
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
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
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?
0
 
Mark WillsTopic AdvisorCommented:
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
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
yeah. so do SP4. thanks.
0
 
Eugene ZCommented:
<Can we move system database from SQL server 2005 SP2, RTM to SQL server 2005 SP4?>
no, you can not

to do it - you must have the same build: sql server edition and SP levels

select @@VERSION  must be the same for sql servers

I would recommend for you to script logins\sql jobs\
 linked servers\
etc.

you can check\try on your own risk:

Moving System Databases
http://msdn.microsoft.com/en-us/library/ms345408(v=sql.90).aspx

Move all SQL Server system databases at one time
http://www.mssqltips.com/sqlservertip/1604/move-all-sql-server-system-databases-at-one-time/
0
 
marrowyungSenior Technical architecture (Data)Author Commented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now