• 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?

Thanks
0
cisgoro
Asked:
cisgoro
2 Solutions
 
Darius GhassemCommented:
I would deattach the DBs the reattach or make backups then restore the DBs in the new SQL server.
0
 
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.
0

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