DB Restore

Is it possible to restore a sql 2000 backup to sql 7.0 .
If yes, is it direct '
If no, what are the all option (work-around) to get this done '
Changing the compatibility level of 2K db to 7.0 and then backup the 2K db,
will this backup able to restore to sql 7.0 '
Thanks
ShShamim,
Q#1,2: No.
Q#3: bcp or DTS.Refer question No.2 in
INF: Frequently Asked Questions - SQL Server 2000 - Upgrade
http://support.microsoft.com/default.aspx?scid=kb;en-us;261334
Q#4: No.
--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:OSDK3XgUDHA.2268@.TK2MSFTNGP11.phx.gbl...
> Is it possible to restore a sql 2000 backup to sql 7.0 .
> If yes, is it direct '
> If no, what are the all option (work-around) to get this done '
> Changing the compatibility level of 2K db to 7.0 and then backup the 2K
db,
> will this backup able to restore to sql 7.0 '
> Thanks
> Sh
>|||Restoring a SQL Server 2000 database to SQL Server 7 is not possible,
alternative would be to use DTS to
transfer the objects from 2000 to 7 or use BCP
> Changing the compatibility level of 2K db to 7.0 and then backup the 2K
db,
> will this backup able to restore to sql 7.0 '
Changing compatibility level will not make any difference.
--
-Vishal
"Shamim" <shamim.abdul@.railamerica.com> wrote in message
news:OSDK3XgUDHA.2268@.TK2MSFTNGP11.phx.gbl...
> Is it possible to restore a sql 2000 backup to sql 7.0 .
> If yes, is it direct '
> If no, what are the all option (work-around) to get this done '
> Changing the compatibility level of 2K db to 7.0 and then backup the 2K
db,
> will this backup able to restore to sql 7.0 '
> Thanks
> Sh
>