Possible to use DB created in SQLServer2005 in SQLServer2000 ?

Tech-Archive recommends: Fix windows errors by optimizing your registry

Here's what we are trying to do :

1) Create a new databse in SQLServer2005, use that database under
SQLServer2005.
2) about a month later, that database is backed up and sent to another site,
which is using SQLServer2000.
3) We want to restore this database at the SQLServer2000 site, and start
using it.

Is step 3) possible ? if so, any gotchas (eg. any special considerations).

TIA,
Stephen



.

Relevant Pages

  • Re: test restore
    ... different server and have some questions. ... I then mounted the database but when i run "alter databse ... How can i use oracle to recognize this ...
    (comp.databases.oracle.server)
  • Re: test restore
    ... different server and have some questions. ... I then mounted the database but when i run "alter databse ...
    (comp.databases.oracle.server)
  • Re: test restore
    ... I then mounted the database but when i run "alter databse ... suning backup controlfile it keeps looking for the other archvile log ... How can i use oracle to recognize this ...
    (comp.databases.oracle.server)
  • Re: DTS
    ... >I have a question regarding DTS in SQL Server, ... >tables present in databse A to tables present in database B. ... DTS package creator is very helpfull on this, ...
    (comp.lang.cobol)
  • Re: Close Database - VFP 9 - Changed
    ... I am testing in the development environment. ... > Hi Devendra, ... > database was opened in the Project Manager by expanding its node or when a ... >> I am doing on selecting on new company, I close old databse and open ...
    (microsoft.public.fox.vfp.dbc)