• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 308
  • Last Modified:

SQL Server 2005

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?

2 Solutions
Darius GhassemCommented:
I would deattach the DBs the reattach or make backups then restore the DBs in the new SQL server.
Raja Jegan RSQL Server DBA & ArchitectCommented:
Hope the Destination server was using SQL Server 2005 client but is there any possibility that it points to a SQL Server 2000 database.

Otherwise you should not obtain that error in Copy Database wizard.
Or you can try other two methods:
1. Backup from Source and then Restore it in Destination Server.
2. Detach in Main and then Attach in Destination Server.

Featured Post

Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now