Not sure about 2000 to 7. there may be conversion tools out there to
take the 2000 version DB back to a version 7 DB. However, you cannot
restore directly from a 2000 backup to a 7 box.

Restoring from SQL 7 to 2000 is not a problem. You may restore the
backup into a shell DB or use Detach/Attach. SQL Server will
automatically upgrade the DB.

Stephen Holland
Consultant
Technical Services
PeopleClick, Inc.


-----Original Message-----
From: aaron [mailto:[Email Address Removed]
Sent: Thursday, September 18, 2003 1:48 PM
To: LazyDBA.com Discussion
Subject: RE: SQL 2000 backup

Can a SQL 7 be restored to SQL 2ooo?

-----Original Message-----
From: Sean Montgomery [mailto:[Email Address Removed]
Sent: September 18, 2003 2:16 PM
To: LazyDBA.com Discussion
Subject: SQL 2000 backup

Can a SQL 2000 backup be restored to a SQL 7 server?

Thanks
Sean

---------------------------------------------------------------------
TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY To
unsubscribe, e-mail: mssqldba-[Email Address Removed] For additional
commands, e-mail: mssqldba-[Email Address Removed] REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To unsubscribe, e-mail: mssqldba-[Email Address Removed] additional commands, e-mail: mssqldba-[Email Address Removed]MS Sql Server LazyDBA home page