I'm tasked with doing a SQL Server 2000 to 2005 migration. I will be doing a side-by-side migration. I've read from a few different sources that I can either:
Perform a backup of the database on SQL Server 2000, ship that backup to the new hardware and restore the database in SQL Server 2005; or
Detach the database on SQL Server 2000, copy the data and log files to the new hardware and attach the files in SQL Server 2005.
Is there a difference between these methods? Which is the safest?
I've been through the pre-upgrade tasks of checking the database with Upgrade Advisior and I have no warnings to resolve before the migration.
Any comments would be greatly received.