Wednesday, March 21, 2012

restore SQL 2005 DB in 2000

A 2000 DB can be restored in SQL 2005 server no problem there. But is there
a
way to restore a SQL Server 2005 DB into SQL server 2000? It keeps erroring
out. Does it mean there is no backward compatibility?"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:B58AA5DD-7478-4656-AFCC-4360F8006F61@.microsoft.com...
>A 2000 DB can be restored in SQL 2005 server no problem there. But is there
>a
> way to restore a SQL Server 2005 DB into SQL server 2000? It keeps
> erroring
> out. Does it mean there is no backward compatibility?
Correct.
When you restore a 2000 DB to 2005, 2005 makes a few chances to the DB.
Since 2000 doesn't know what those changes are, you can't go backwards.
Greg Moore
SQL Server DBA Consulting Remote and Onsite available!
Email: sql (at) greenms.com http://www.greenms.com/sqlserver.html|||Morphius
I don't think 'backward compatibility is the right term here. It's 'forward
compatibility that is a problem.
Metadata changed completely in SQL Server 2005, so your files from your SQL
2005 database contain system information that is completely unintelligible
to the SQL 2000 Engine. The SQL 2005 engine can understand the SQL 2000
files, because it knows the way things used to be. But the SQL 2000 engine
was not built to know how things might change and to be able to interpret
every possible change, so they don't know how to interpret the new metadata,
and other changes to files, pages and rows, that were added in SQL 2005.
HTH
Kalen Delaney, SQL Server MVP
www.InsideSQLServer.com
http://sqlblog.com
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:B58AA5DD-7478-4656-AFCC-4360F8006F61@.microsoft.com...
>A 2000 DB can be restored in SQL 2005 server no problem there. But is there
>a
> way to restore a SQL Server 2005 DB into SQL server 2000? It keeps
> erroring
> out. Does it mean there is no backward compatibility?|||Hello,
Due to architectural changes you can restore a SQL Server 2005
databasebackup back into SQL 2000. You could take the script out create all
objects and then
use SQL Server integration services or DTS to copy the data.
Thanks
Hari
"morphius" <morphius@.discussions.microsoft.com> wrote in message
news:B58AA5DD-7478-4656-AFCC-4360F8006F61@.microsoft.com...
>A 2000 DB can be restored in SQL 2005 server no problem there. But is there
>a
> way to restore a SQL Server 2005 DB into SQL server 2000? It keeps
> erroring
> out. Does it mean there is no backward compatibility?sql

No comments:

Post a Comment