Printable View
I have a database in sql server 2000 and need to backup and restore it onto sql express 2005 which is installed on the same server.
I was hoping I could just backup the sql server 2000 db and restore it but that doesn't seem to work.
Anyone have any ideas ?
TIA
how did you tried to restore it (using enterprise Manager?)? did you got any message?
It most certainly does work - BACKUP in a query window - makes a .BAK file.
RESTORE in another query windows restores it and converts it up to 2005 level.
You cannot go back the other way!!
If you need to see example of the BACKUP and RESTORE syntax search the forum for BACKUP FUNDS