On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. A
fter repeated attempts the server did not update. I got no errors and it lo
oked like it had installed on the default database but every time I check th
e version, I was on sp2. S
o now I have a new server with Server 2003 installed and will be moving my d
atabases over there. So I have installed Sql Server 2000 sp2. I will then
be installing sp3a. Will there be any problems with restoring the master, t
emp, and all over databases
from Win 2000 sp2 server TO Server 2003 sp3a server?
Thanks for any guidance you can provide.I would have thought doing this would be a bad idea, as the restored master,
temp, msdb db's etc would be a different version to most of the server.
You are probably better off trying to update it after restoring your dbs.
Cheers,
James Goodman MCSE, MCDBA
http://www.angelfire.com/sports/f1pictures|||Can not really do that because Server 2003 needs to have Sql Server 2000 sp3
a installed.
Wednesday, March 7, 2012
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment