Master database restore sql 2000 SP3/SP4

[ronnie001]

All,

Is it supported to backup the master db from a server running SQL 2000 SP3a and restore to a server running SQL 2000 SP4?

(I am planning to move all my DB's from an old server to a new one)

Thanks for any advice.

Cheers,

Ronnie

 

[mrdenny]

Nope, there are changes to system objects between the versions. You'll want the new server at the same release (including any hot fixes) as the old server. Then upgrade to SP4 after you restore the databases.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com

 

[ronnie001]

Hi Denny,

I removed my SQL server and reinstalled it and loaded SP3a after....restoring the master database after that was done with no problems.

I'll reload SP4 after I have finished all my restores.

Thanks!

Cheers,

Ronnie

 

[mrdenny]

no problem.

Denny
MCSA (2003) / MCDBA (SQL 2000)

--Anything is possible. All it takes is a little research. (Me)

http://www.mrdenny.com