SQL server upgrade(hardware)

[jgdx4]

I need to move SMS SQL DB to new server. Is there a documented procedure available? I've attempted this in test environment and can't connect SMS console back to site DB.

 

[Jpoandl]

You can inplace upgrade the old server to Windows 2000. Then backup and restore this to the new hardware. SMS will not even know that anything moved. However, it is difficult to perform this hardware swap...especially if the hardware is different. I have performed a hardware swap and it seems to work fine for file servers..I haven't yet tried for application server. I don't see why my procedure wouldn't work.

Joseph L. Poandl
MCSE 2000

If your company is in need of experts to examine technical problems/solutions, please check out

http://www.esavio.com

 

[jgdx4]

In place upgrades are not usually an option. We have a server team that does all are builds and that would just blow them away. I think we're going to take an approach that involves renaming the SQL server and then doing a site reset to reconnect the DB. We tryed this in the lab had a few problems with security. We're going to reset in the lab for another shot at it. thanks