Moving SQL2k to new appliance

I am moving a SQL 2k database from a Windows 2000 server to a Windows 2003 server (seperate appliances) and would like as little SQL downtime as possible.

I have several applications that I believe are connecting to servernow by servernow’s name and don’t want to have to figure out how to change them to servernew.Would it work if I built servernew and copied/moved the SQL database to servernew, then take servernow off line and change servernew’s name to servernow?

I am open to any suggestions on other more appropriate methods.

Thanks in advance

Melonheads Sister

That suggestions should work. Ensure you follow the instructions at http://msdn2.microsoft.com/en-us/library/ms143799.aspx for renaming the server. Ensure you move over the logins.

Thanks,

Peter Saddow

|||

Hi,

i would suggest to refer http://vyaskn.tripod.com/moving_sql_server.htm for Moving SQL Server complete idea.

Hemantgiri S. Goswami

|||

Thank you both. Looks like both documents will be very useful.

Melonheads Sister