Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 Database restore

Author  Topic 

stevenchoon
Starting Member

8 Posts

Posted - 2006-06-05 : 04:12:12
Dear everyone,
can we restore sql server 2005 database into sql server 2000?
i get error message when try to restore it to server 2000.

steven

khtan
In (Som, Ni, Yak)

17689 Posts

Posted - 2006-06-05 : 04:15:35
Why do you want to do this ?

Don't think you can do it. You can restore a SQL 2000 DB into SQL 2005 server but not the other way round.


KH

Go to Top of Page

mr_mist
Grunnio

1870 Posts

Posted - 2006-06-05 : 05:13:56
You can't do this. If you want to move data you'd have to export and import it.

-------
Moo. :)
Go to Top of Page

SreenivasBora
Posting Yak Master

164 Posts

Posted - 2006-06-21 : 17:46:07
Even You cant use Attach/detatch the database files. Use DTS wizard or export/Import as suggested above.

With Regards
BSR
Go to Top of Page
   

- Advertisement -