?
Solved

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

Posted on 2013-01-30
11
Medium Priority
?
596 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
11 Comments
 
LVL 1

Author Comment

by:marrowyung
ID: 38838193
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 200 total points
ID: 38838271
0
 
LVL 1

Author Comment

by:marrowyung
ID: 38838494
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
Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

 
LVL 1

Author Comment

by:marrowyung
ID: 38838500
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 1000 total points
ID: 38838944
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
 
LVL 51

Expert Comment

by:Mark Wills
ID: 38838977
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
ID: 38839966
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
ID: 38840236
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
ID: 38842368
yeah. so do SP4. thanks.
0
 
LVL 43

Assisted Solution

by:Eugene Z
Eugene Z earned 800 total points
ID: 38846683
<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
ID: 38888130
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function
Suggested Courses

770 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