sandorka
asked on
SQL 2000 -> SQL 2005 assistance
I am in the process of moving databases from a SQL 2000 server to a SQL 2005 server with the backup/restore method, but the process iserroring out. Does anyone know how to convert/move databases?
Backup the database in SQL server 2000,copy the .bak file into the new server.Restore it from the management console.It is pretty straight forward.By the way,what is the error you are getting.
I have done this many times in my company
I have done this many times in my company
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
an alternate way is to stop 2000, copy the mdf, ldf files (both) and any other files (ndf) and use
sp_attach_db from 2005. similarly to backup/restore, sql will automatically upgrade the databases and introduce the sql 2005 sys. tables on attachment/restore
sp_attach_db from 2005. similarly to backup/restore, sql will automatically upgrade the databases and introduce the sql 2005 sys. tables on attachment/restore
What are your error messages?
ASKER