Copy Database from v8 to v9 SQL Server

Hi dear devs, admins or users!

I have following problem with the "SQL Server 2005 Developer Edition". I am in a small network and try to copy a database from a version 8.0 to a version 9.0 "SQL Server" (2 computers). I use the "Copy Database Wizard" and the process did 4 from 5 actions correctly, the last action with the name "Execute SQL Server Agent Job" fails allways. My "SQL Server Agent" process is started and runs well. In real I don't need the "SQL Server Agent" in any way in my database, so I don't understand why this process generates this error. I try to copy this old "Portal" "ASP.NET 1.1" database to my new "SQL Server 2005". Can someone help me?.

Thanks

Arzu Bazman · «US DEV United Systems»

You can try to detach your database in SQL Server 2000 and go to the folder where your database's .mdf and .ldf are located to copy them. Then paste the copied files to your SQL Server 2005 data file folder (somewhere like: C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\). Go to the MS management Studio and retach the database. The database should be ready to go.

Or you can back up your database and restore it in your new server.

HTH.

|||

msbazman:

Hi dear devs, admins or users!

I have following problem with the "SQL Server 2005 Developer Edition". I am in a small network and try to copy a database from a version 8.0 to a version 9.0 "SQL Server" (2 computers). I use the "Copy Database Wizard" and the process did 4 from 5 actions correctly, the last action with the name "Execute SQL Server Agent Job" fails allways. My "SQL Server Agent" process is started and runs well. In real I don't need the "SQL Server Agent" in any way in my database, so I don't understand why this process generates this error. I try to copy this old "Portal" "ASP.NET 1.1" database to my new "SQL Server 2005". Can someone help me?.

Thanks

Arzu Bazman · «US DEV United Systems»

The Agent is not related unless you tried to schedule the move, here is what you do depending on your needs, register the 2000 with the 2005 in Management Studio right click all task then Backup the database in 2000 locally and then restore it in the 2005 in the Backup and Restore wizard choose the restore from device option, SQL Server will ask you if you want to keep 2000 compatibility choose what you need. Hope this helps.