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 2005 Forums
 SQL Server Administration (2005)
 migrate SQL2005 to SQL 2000

Author  Topic 

naushi
Starting Member

10 Posts

Posted - 2009-03-17 : 13:13:49
We need to migrate a sql 2005 database to sql 2000 for some business reasons. Any onw knows how do we do that. it wont take 2005 backup and restore it in 2000
thanks in advance

naushi hussain

mfemenel
Professor Frink

1421 Posts

Posted - 2009-03-17 : 13:21:51
The only thing I can think of is that you'd script out your 2005 database, run it on your 2000 database and copy the data into the empty structure. Actually before you copy data into the empty structure, backup the database so you have it if you need it again.

Mike
"oh, that monkey is going to pay"
Go to Top of Page
   

- Advertisement -