Restore SQL 2000 database onto a SQL 7 box

Is it possible to restore a SQL 2000 database backup onto a SQL 7 box?

I tried and it quite rightly complained about database structure versions are different.

Is there a way to backup SQL 2000 in such a way that only SQL 7 features are preserved? and thus can be restored on to a SQL 7 box.

The database it self is really quite simple. Just tables (plus data) and SPs.No you can't restore a 2K database onto a 7 box. You can use DTS to move data OR BCP the data out of the 2K box and into the 7 box.

Restore of System databases... in earlier to SQL 2K versions....

Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2K?
How did earlier versions of SQL Server 2K use to restore the system
databases?
http://support.microsoft.com/default...b;en-us;169039
As per the above link it seems to be there is no trace of restoring the
MASTER or MSDB databases as explained in SQL 2K documentation.
Thank you for your comment,
Allen
Restore of the system databases has worked the same way across all versions of SQL Server (well,
msdb was introduced in 6.0).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"AllenHubatka" <AllenHubtka_67@.hotmail.com> wrote in message
news:uhvZCEFqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>
> Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2K?
> How did earlier versions of SQL Server 2K use to restore the system
> databases?
> http://support.microsoft.com/default...b;en-us;169039
> As per the above link it seems to be there is no trace of restoring the
> MASTER or MSDB databases as explained in SQL 2K documentation.
> Thank you for your comment,
> Allen
>
>
>

Restore of System databases... in earlier to SQL 2K versions....

Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2K?
How did earlier versions of SQL Server 2K use to restore the system
databases?
http://support.microsoft.com/default.aspx?scid=kb;en-us;169039
As per the above link it seems to be there is no trace of restoring the
MASTER or MSDB databases as explained in SQL 2K documentation.
Thank you for your comment,
AllenRestore of the system databases has worked the same way across all versions of SQL Server (well,
msdb was introduced in 6.0).
--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"AllenHubatka" <AllenHubtka_67@.hotmail.com> wrote in message
news:uhvZCEFqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>
> Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2K?
> How did earlier versions of SQL Server 2K use to restore the system
> databases?
> http://support.microsoft.com/default.aspx?scid=kb;en-us;169039
> As per the above link it seems to be there is no trace of restoring the
> MASTER or MSDB databases as explained in SQL 2K documentation.
> Thank you for your comment,
> Allen
>
>
>

Restore of System databases... in earlier to SQL 2K versions....

Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2K?
How did earlier versions of SQL Server 2K use to restore the system
databases?
http://support.microsoft.com/defaul...kb;en-us;169039
As per the above link it seems to be there is no trace of restoring the
MASTER or MSDB databases as explained in SQL 2K documentation.
Thank you for your comment,
AllenRestore of the system databases has worked the same way across all versions
of SQL Server (well,
msdb was introduced in 6.0).
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://www.solidqualitylearning.com/
Blog: http://solidqualitylearning.com/blogs/tibor/
"AllenHubatka" <AllenHubtka_67@.hotmail.com> wrote in message
news:uhvZCEFqFHA.3160@.TK2MSFTNGP14.phx.gbl...
>
> Restoring of Master/MSDB databases used in SQL 2K is a new feature in SQL2
K?
> How did earlier versions of SQL Server 2K use to restore the system
> databases?
> http://support.microsoft.com/defaul...kb;en-us;169039
> As per the above link it seems to be there is no trace of restoring the
> MASTER or MSDB databases as explained in SQL 2K documentation.
> Thank you for your comment,
> Allen
>
>
>