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?
ThanksGloria,
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...
> >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
>
>|||I noticed when I opened SQL Server 2005 that my server was listed as a SQL
Server 2000 type. It looks like this:
Server Name (SQL Server 8.0......)
The '8.0' I believe means that it is SQL Server 2000 and not 2005.
When it is 2005, it is SQL Server 9.0.3042
When you start SQL 2005, the dialog box lists the server names. In my case,
my server group is on my machine so I added '\SQLEXPRESS' to the name of my
machine and it identified it as Server 9.0.3042.
"William" wrote:
> Hi, I would like to know if you could find the solution to this problem because it's happening to me too.
> I'm traying to restore a backup from sql 2005 to a database in sql 2005 too. The message is the same that yours.
> I appreciate your answer.
> Thanks!!!
>