Solved

move system database from SQL server 2005 SP2, RTM to SQL server 2005 SP4

Posted on 2013-01-30
11
580 Views
Last Modified: 2013-02-14
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
Comment
Question by:marrowyung
11 Comments
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
Also we can simply upgrade SQL server 2005 RTM and SP2 to SP4 directly, right? any step-by-step guide?
0
 
LVL 10

Assisted Solution

by:deviprasadg
deviprasadg earned 50 total points
Comment Utility
0
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
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
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
sorry I should add one more like, can we upgrade from SQL server 2005 RTM to SP4 also ?
0
 
LVL 51

Accepted Solution

by:
Mark Wills earned 250 total points
Comment Utility
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
IT, Stop Being Called Into Every Meeting

Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

 
LVL 51

Expert Comment

by:Mark Wills
Comment Utility
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
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
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
 
LVL 51

Expert Comment

by:Mark Wills
Comment Utility
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
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
yeah. so do SP4. thanks.
0
 
LVL 42

Assisted Solution

by:EugeneZ
EugeneZ earned 200 total points
Comment Utility
<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
 
LVL 1

Author Comment

by:marrowyung
Comment Utility
0

Featured Post

Better Security Awareness With Threat Intelligence

See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

Join & Write a Comment

In this article I will describe the Copy Database Wizard method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.
Viewers will learn how the fundamental information of how to create a table.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

15 Experts available now in Live!

Get 1:1 Help Now