Kevin Remde's IT Pro Weblog
IT Pro Resources
TechNet EventsMicrosoft Security Response CenterTechNet IT Manager Community HubMicrosoft Virtual AcademyKevin’s Evaluation Download Center
IT Pro Evangelist Blogs
Blain Barton Blain Barton's Blog@BlainBar
Brian LewisMy Thoughts on IT...@BrianLewis_
Dan Stolts IT Pro Guru Blog@ITProGuru
Jennelle Crothers TechBunny@jkc137
Keith MayerIT Pros ROCK!@KeithMayer
Kevin Remde Full of I.T.@KevinRemde
Matt Hester Matthew Hester's WebLog@MatthewHester
Tommy PattersonVirtually Cloud 9@Tommy_Patterson
Yung Chou Yung Chou on Hybrid Cloud@YungChou
SQL Server 2005 Tidbit 004
Another one! Number four…
This tidbit comes as a result of a question an attendee from one of our live TechNet Events emailed me.
"We have a multiserver environment with one master server and twenty-four instances of SQL Server as target servers. Will multiserver work in a multi-versioned environment? In other words, if I upgrade the master server to Yukon, will it still be able to download instructions, etc., to the target servers if they are running SQL Server 2000? If one of the target servers is upgraded to Yukon, will the master server running SQL Server 2000 choke?”
It's important to upgrade whatever server you're using as the central distributor first. That's where the services run. Once that's done, though, it doesn't matter which of the others you upgrade next. 2000 publishers can talk to 2005 subscribers, and vice versa.
Got an IT question? Give me a comment, or contact me.