> We have a huge database on SQL 2005 and there are hundreds of users
> having the copy of this datbase on SQL 2000
>
> We used to provide backup dump file for them to restore
> Now with SQL 2005, I have read that we can not restore a dump from
> 2005 on
> to 2000
> Is there any alternate method or third party tools that can do a
> restore onto 2000 from 2005. Export and import of individual tables is
> very time consuming and we do not want to use it as it has to be done
> almost daily basis.
>
> Kiran
>

"Allan Mitchell" wrote:

> Hello Kiran,
>
>
> You will not be able to do a RESTORE from 2005 to 2000. I know of no way
> other than doing as you have suggested to make this happen.
>
>
> Allan
>
> > We have a huge database on SQL 2005 and there are hundreds of users
> > having the copy of this datbase on SQL 2000
> >
> > We used to provide backup dump file for them to restore
> > Now with SQL 2005, I have read that we can not restore a dump from
> > 2005 on
> > to 2000
> > Is there any alternate method or third party tools that can do a
> > restore onto 2000 from 2005. Export and import of individual tables is
> > very time consuming and we do not want to use it as it has to be done
> > almost daily basis.
> >
> > Kiran
> >
>
>