Re: Possible to use DB created in SQLServer2005 in SQLServer2000 ?



No. You can't restore a SQL Server 2005 backup to SQL Server 2000 and
you can't use detach/attach.

-Sue

On Wed, 14 Mar 2007 11:30:23 +1100, "Stephen Ahn" <noaddress> wrote:

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: SQL 2000 SP4 on 2003 Server - Single User Mode
    ... I found the section where you list the filename to restore to. ... rename the SQL Server the same as what is listed below Courthouse? ... Once you've created your database (simply right click on the Database ...
    (microsoft.public.sqlserver.setup)
  • Re: Moving databases from SQL 7 to SQL 2000 - More Questions!
    ... want to run sp_updatestats after the restore or attach as well. ... >>There is a lot more that can go wrong with the wizard ... > SQL Server Databases ... >>Issues When a Database Is Moved Between SQL Servers ...
    (microsoft.public.sqlserver.setup)
  • Re: HELP!!! restore database - left in loading state?? PLEASE H
    ... RESTORE DATABASE WITH RECOVERY ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.tools)
  • Re: Restore Master DB to New Server
    ... the user database will be suspect. ... Just drop them and then do the restore. ... Tibor Karaszi, SQL Server MVP ...
    (microsoft.public.sqlserver.tools)
  • Re: Migration ?
    ... I've tried every way I can think of trying to restore the master database. ... Will a restore on the SQL ... Install a SQL Server failover cluster instance ...
    (microsoft.public.sqlserver.clustering)