Error: Too many backup devices specified

I am new to SQL Server 2005.
I am trying to restore a database on my computer using SQL Server 2005.
In SQL 2000, I could create the database and then restore a backup over it.
I tried doing this in SQL 2005 and I get the Error:
Too many backup devices specified for backup or restore; only 64 allowed.
Error: 3205.
In the 'Restore Database' window, I select the database and I select, 'From
Device' and point to the backup file to restore. From the 'Specify Backup'
window, I select the backup file, I get the above error.
What am I doing wrong?
Thanks
Gloria,
It seems that most of the people who run into this are trying to restore a
2005 database to a 2000 server.
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
The description of your problem does not sound like you are doing this (or
at least not intentionally) but you might check it out.
Do you backup to multiple files or do you use single file backups? SQL
Server 2000 had a problem restoring multi-file backups, but that was fixed
in 2000 and should be working fine in SQL Server 2005.
RLF
"Gloria" <Gloria@.discussions.microsoft.com> wrote in message
news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
>I am new to SQL Server 2005.
> I am trying to restore a database on my computer using SQL Server 2005.
> In SQL 2000, I could create the database and then restore a backup over
> it.
> I tried doing this in SQL 2005 and I get the Error:
> Too many backup devices specified for backup or restore; only 64 allowed.
> Error: 3205.
> In the 'Restore Database' window, I select the database and I select,
> 'From
> Device' and point to the backup file to restore. From the 'Specify
> Backup'
> window, I select the backup file, I get the above error.
> What am I doing wrong?
> Thanks
|||We use single file backups.
The file is from SQL 2005 and I am trying to restore it in SQL 2005 BUT, I
do have SQL 2000 on my computer also and the other databases that I see in
the database list (Object Explorer are SQL 2000 ).
I will check out the links you sent and will continue troubleshooting.
Thanks,
"Russell Fields" wrote:

> Gloria,
> It seems that most of the people who run into this are trying to restore a
> 2005 database to a 2000 server.
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=722132&SiteID=1
> http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1
> The description of your problem does not sound like you are doing this (or
> at least not intentionally) but you might check it out.
> Do you backup to multiple files or do you use single file backups? SQL
> Server 2000 had a problem restoring multi-file backups, but that was fixed
> in 2000 and should be working fine in SQL Server 2005.
> RLF
> "Gloria" <Gloria@.discussions.microsoft.com> wrote in message
> news:E51D26A7-88C0-4580-9722-40D84E17B6E9@.microsoft.com...
>
>