Restore backup from sql server 2005 to 2000
-
Hi, I have database backup from sql server 2005, i want to restore that backup file to sql server 2000. I have tried attach database and restore database but i am not able to do that. Is there any way to achieve this? please help me.
Thanks Warm Regards Prakash-B
-
Hi, I have database backup from sql server 2005, i want to restore that backup file to sql server 2000. I have tried attach database and restore database but i am not able to do that. Is there any way to achieve this? please help me.
Thanks Warm Regards Prakash-B
Backups created with Microsoft SQL Server 2005 cannot be restored to an earlier version of SQL Server. With the help of Export/Import OR some third party Tool you can transfer your data from 2005 to 2000 and this is the way only.
Parwej Ahamad R & D with IIS 5.0/6.0
modified on Friday, June 13, 2008 11:57 AM
-
Hi, I have database backup from sql server 2005, i want to restore that backup file to sql server 2000. I have tried attach database and restore database but i am not able to do that. Is there any way to achieve this? please help me.
Thanks Warm Regards Prakash-B
Seems reasonable to me, what makes you beleive you will be able to restore a 05 DB on 2000. I would have thought this would be a futile effort. You will be able to DTS, or select the data across. You may even be able to use replication but restore, not a chance.
Never underestimate the power of human stupidity RAH