On my current install of Win 2000 Sql Server sp2 I tried to install sp3a. After repeated attempts the server did not update. I got no errors and it looked like it had installed on the default database but every time I check the version, I was on sp2. So now I have a new server with Server 2003 installed and will be moving my databases 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, temp, 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 sp3a installed.
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment