Copy database wizard fails - copying 2000 dbs to new 2005 server

Hi, we recently upgraded our test database server to SQL 2005. We are trying
to use the "Copy Database Wizard" in 2005 to copy SQL 2000 databases over to
the new test server. However, during the "Execution job" phase we receive
the following error message in the event log:
Event ID: 12550
Description:
Event Name: OnError
Message: Version80 database compatibility level is not supported.
any ideas on how I can resolve this issue? I have tried the export data
function and it works, however, we have stored procedures and DTS's set up on
these databases and would like a complete copy of the database on SQL 2005.
Any assistance is greatly appreciated.
Thanks!
Hi
"SoulCages" wrote:

> Hi, we recently upgraded our test database server to SQL 2005. We are trying
> to use the "Copy Database Wizard" in 2005 to copy SQL 2000 databases over to
> the new test server. However, during the "Execution job" phase we receive
> the following error message in the event log:
> Event ID: 12550
> Description:
> Event Name: OnError
> Message: Version80 database compatibility level is not supported.
> any ideas on how I can resolve this issue? I have tried the export data
> function and it works, however, we have stored procedures and DTS's set up on
> these databases and would like a complete copy of the database on SQL 2005.
> Any assistance is greatly appreciated.
> Thanks!
I am not sure why you are not attaching the database files or restoring
backups?
John
|||John,
The two servers I am working with are on non-trusted domains and rather than
take all of our databases offline to copy them over to the server I was
hoping there was a way to do it while the databases are still online. (tried
using both methods in the copy database wizard but they fail with the message
below).
My goal is to bring the databases over exactly as they are today in SQL 2000
but migrate them to a 2005 testbed before we upgrade our existing SQL 2000
server to 2005 and set up replication.
I tried using the backup and attach methods but they do not allow you to
point to a network share. Both servers are in different buildings. What is
your recommended approach to handling this?
Thanks John,
Ryan Harris
"John Bell" wrote:

> Hi
> "SoulCages" wrote:
>
> I am not sure why you are not attaching the database files or restoring
> backups?
> John
|||Hi Ryan
"SoulCages" wrote:

> John,
> The two servers I am working with are on non-trusted domains and rather than
> take all of our databases offline to copy them over to the server I was
> hoping there was a way to do it while the databases are still online. (tried
> using both methods in the copy database wizard but they fail with the message
> below).
> My goal is to bring the databases over exactly as they are today in SQL 2000
> but migrate them to a 2005 testbed before we upgrade our existing SQL 2000
> server to 2005 and set up replication.
> I tried using the backup and attach methods but they do not allow you to
> point to a network share. Both servers are in different buildings. What is
> your recommended approach to handling this?
> Thanks John,
> Ryan Harris
>
You should be able to copy a backup file between the servers is probably
preferable to restoring from a UNC filename. You can then restore from the
copied file.
Database files can not be on a shared drive.
Have you run the SQL 2005 Upgrade Advisor on the current server?
HTH
John