Detach db from SQL 2005 and attach to SQL 2000

Can I detach a database from SQL 2005 server and attach it to SQL 2000
server? Any additional steps required?No, you cannot attach to a SQL Server with a lower version level.
--
HTH
Kalen Delaney, SQL Server MVP
http://sqlblog.com
"Zack" <svoiasgfs@.sdlgweg90dflg.com> wrote in message
news:OJIP0nzDHHA.2176@.TK2MSFTNGP04.phx.gbl...
> Can I detach a database from SQL 2005 server and attach it to SQL 2000
> server? Any additional steps required?
>|||No you cannot. The datafile formats are not compatible.
--
Arnie Rowland, Ph.D.
Westwood Consulting, Inc
Most good judgment comes from experience.
Most experience comes from bad judgment.
- Anonymous
You can't help someone get up a hill without getting a little closer to the
top yourself.
- H. Norman Schwarzkopf
"Zack" <svoiasgfs@.sdlgweg90dflg.com> wrote in message
news:OJIP0nzDHHA.2176@.TK2MSFTNGP04.phx.gbl...
> Can I detach a database from SQL 2005 server and attach it to SQL 2000
> server? Any additional steps required?
>|||Hello,
Database can not be copied or restored from a higher version to lower
version. Use the SQL Server integration service [SSIS] or DTS to copy
the objects and data from SQL 2005 to SQL 2000.
Thanks
Hari
"Zack" <svoiasgfs@.sdlgweg90dflg.com> wrote in message
news:OJIP0nzDHHA.2176@.TK2MSFTNGP04.phx.gbl...
> Can I detach a database from SQL 2005 server and attach it to SQL 2000
> server? Any additional steps required?
>