| Author |
2005 DB backwards-compatible to 2000?
|
|
|
| I've attached an SQL2000 db to an SQL2005 Std installation and am curious if
that process can go the other way. Can you detach from 2005 and attach to
2000 without any issues?
| |
| Chris O'C via SQLMonster.com 2006-12-13, 12:13 am |
| Earl wrote:
> Can you detach from 2005 and attach to
> 2000 without any issues?
No. One cannot attach a higher version database to a lower version SQL
Server. The 2005 file format is incompatible with SQL Server 2000.
If you have to migrate backwards, use SSIS to copy the objects and data from
SQL Server 2005 to SQL Server 2000.
--
Message posted via webservertalk.com
http://www.webservertalk.com/Uwe/Fo...server/200612/1
| |
| Hari Prasad 2006-12-13, 12:13 am |
| No, You can not do that because of architectural changes.
Thanks
Hari
"Earl" <brikshoe@newsgroups.nospam> wrote in message
news:%23ye9a5kHHHA.3540@TK2MSFTNGP02.phx.gbl...
> I've attached an SQL2000 db to an SQL2005 Std installation and am curious
> if that process can go the other way. Can you detach from 2005 and attach
> to 200use of 0 without any issues?
>
| |
|
| Ahhh, thanks Chris and Hari. Tis' the answer I need.
"Chris O'C via webservertalk.com" <u29189@uwe> wrote in message
news:6aacc6ece6f0b@u
we...
> Earl wrote:
>
> No. One cannot attach a higher version database to a lower version SQL
> Server. The 2005 file format is incompatible with SQL Server 2000.
>
> If you have to migrate backwards, use SSIS to copy the objects and data
> from
> SQL Server 2005 to SQL Server 2000.
>
> --
> Message posted via webservertalk.com
> http://www.webservertalk.com/Uwe/Fo...server/200612/1
>
|
|
|
|