Moving SQL 2005 database to SQL2000

I have a SQL Server 2005 RTM database that I need to move to SQL2000. Under
2005 Beta 2 I was able to save the database under 2005 and then restore it
under 2000. Now with RTM I get an error 3205: "Too many backup devices
specified for backup or restore; only 64 are allowed."
Is there a way of getting the database (tables and stored procs) into 2000?
Thanks...Yes, there is a way, but not via backup/restore or detach/attach. You'll
have to copy the data using a tool such as SSIS, DTS, linked servers, or
BCP.
Adam Machanic
Pro SQL Server 2005, available now
http://www.apress.com/book/bookDisplay.html?bID=457
--
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:6EE9FA6D-4CEE-4DF9-81AA-95535FA8C756@.microsoft.com...
>I have a SQL Server 2005 RTM database that I need to move to SQL2000.
>Under
> 2005 Beta 2 I was able to save the database under 2005 and then restore it
> under 2000. Now with RTM I get an error 3205: "Too many backup devices
> specified for backup or restore; only 64 are allowed."
> Is there a way of getting the database (tables and stored procs) into
> 2000?
> Thanks...|||Thanks Adam.
Will SSIS copy everything (including the stored procs) or will it just copy
the data?
- Steve
"Adam Machanic" wrote:

> Yes, there is a way, but not via backup/restore or detach/attach. You'll
> have to copy the data using a tool such as SSIS, DTS, linked servers, or
> BCP.
>
> --
> Adam Machanic
> Pro SQL Server 2005, available now
> http://www.apress.com/book/bookDisplay.html?bID=457
> --
>
> "Steve" <Steve@.discussions.microsoft.com> wrote in message
> news:6EE9FA6D-4CEE-4DF9-81AA-95535FA8C756@.microsoft.com...
>
>|||Hi Steve
As there may be compatibility issues you may be better of scripting the
stored procedures.
John
"Steve" wrote:
[vbcol=seagreen]
> Thanks Adam.
> Will SSIS copy everything (including the stored procs) or will it just cop
y
> the data?
> - Steve
> "Adam Machanic" wrote:
>|||That's up to you and what options you use but yes it can copy all the
database objects.
Andrew J. Kelly SQL MVP
"Steve" <Steve@.discussions.microsoft.com> wrote in message
news:52B70E78-A610-4B06-91A9-94F90C84871F@.microsoft.com...[vbcol=seagreen]
> Thanks Adam.
> Will SSIS copy everything (including the stored procs) or will it just
> copy
> the data?
> - Steve
> "Adam Machanic" wrote:
>