SQLServer 2005 restore to 2000

Hi! anyone who knows how to backup DB from SQLServer 2005 and restore to SQLServer2000?

[quote=sonzls]Hi! anyone who knows how to backup DB from SQLServer 2005 and restore to SQLServer2000?[/quote]



Hello,

I don't think it will work since SQL Server 2000 knows nothing of the new features of SQL Server 2005. There are few tools using which can script your database and create insert statements which you can use to get the data back to sql server 2000.

Thanks,

yes it will be work