Our servers are all leased and it is time to return one of our SQL Servers, storing around 100GB of data. There are multiple databases, users, etc. From the research I've done, it seems to me like the best way is to set up a fail-over replication to make a copy of the server, then basically just pull the plug and change the server name so everything points to the new server. Will this work, or is there a better way to go about this task?
I would install the operating system and SQL Server and then either do backups and restores or detach the database files, copy to the new server and then attach to the new server. You can also use features in Enterprise Manager to help migrate jobs, DTS packages, logins etc…
This way you will have the old and the new server to make sure things are working before you pull the plug. Once things are all set, you can rename the box.
Do you have comments on this Ask the Expert Q&A? Let us know.
Dig Deeper on SQL Server Backup and Recovery
Related Q&A from Greg Robidoux
Avoid restoring your SQL Server database to solve the SQL Server error message "server out of memory." The problem could be the memory settings. Continue Reading
Restore backups in SQL Server 2000 and SQL Server 2005 with this command. Continue Reading
Back up tables from a SQL Server database to a file with these commands. Continue Reading
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.