That brings up 2 points :

1. If the Server Name is different, do I restore Master, then rename the Server ???

2. Can there be two SQL Servers with the...

Steve ->

We do have a whole weekend where the Servers can be down for this Migration.

Would you suggest using Copy Database Wizard or a Manual Detach, Attach ?

-----------

If Manual :

wouldn't...

Thanks guys. This is an awesome site. I have informed all my fellow DBA's about this.

SO, in a situation where the SQL Servers can be taken down for a weekend,...

We can shut down the 2 services for SQL Server.

Would it be better to :

1. Shut down the services - mssqlserver & sqlserveragent.

2. Copy the DB & Log files to...

We have 2 new servers for the Migration.