I am trying to copy over a database from one database server instance to another. The first instance containing the database is SQL Server 2005 and the one I want to transfer it to is SQL Server 2008.
I keep getting an error when I run the Copy Database Command. I was wondering if I could use a copy only backup to restore the database on the new server.
I am largely trying to see if anyone has encountered a similar situation.
Thanks for your help.