I have a server with Windows 2003r2 sp2. I am running sql server 2005 with several databases. I am in the process of copying these databases over to another server with the same OS and also SQL 2005. What would be the easiest way to copy these databases over? When I try to rightclick on one of the databases from SQL server managemnet studio and select try using the copy database wizard i get the following message after clicking on next on the destination:
The destination SQL Server must be SQL Server 2005
But it is Sql server 2005. Any ideas?