SQL Server 2005

Posted on 2009-04-24
Last Modified: 2012-05-06
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?

Question by:cisgoro
    LVL 59

    Accepted Solution

    I would deattach the DBs the reattach or make backups then restore the DBs in the new SQL server.
    LVL 57

    Assisted Solution

    by:Raja Jegan R
    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

    Live: Real-Time Solutions, Start Here

    Receive instant 1:1 support from technology experts, using our real-time conversation and whiteboard interface. Your first 5 minutes are always free.

    Join & Write a Comment

    When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
    Recently, I had the need to build a standalone system to run a point-of-sale system. I’m running this on a low-voltage Atom processor, so I wanted a light-weight operating system, but still needed Windows. I chose to use Microsoft Windows Server 200…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    In this seventh video of the Xpdf series, we discuss and demonstrate the PDFfonts utility, which lists all the fonts used in a PDF file. It does this via a command line interface, making it suitable for use in programs, scripts, batch files — any pl…

    746 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    18 Experts available now in Live!

    Get 1:1 Help Now