error 3205

Question

when i restore database, i made an error:
 
  Server: Msg 3205, Level 16, State 2, Line 3

Too many backup devices specified for backup or restore; only 64 are      allowed. 

Server: Msg 3013, Level 16, State 1, Line 3

RESTORE DATABASE is terminating abnormally.

* my command:
   RESTORE DATABASE tkb

 FROM DISK=’C:\ Program Files\Microsoft SQL       Server\MSSQL\BACKUP\tkb.bak’

WITH FILE = 1,

  NORECOVERY,NOUNLOAD, REPLACE, STATS = 10

*** Help me, please!

Answer 1

 

My guess is that there was a typo in your command or script that confused the parser into thinking that you had specified more devices for the restore than you had.

 

Is this the EXACT command you used?  Can you cut and paste from a script?

If it wasn't a script, have you tried re-typing and re-running the command?

Answer 2

Hi,

    I think it is not possible to restore a Sql server 2005 backup to Sql server 2000. So restore the backup to Sql server 2005 environment, it will work.

Answer 3

All the messages I have read on all the forums seem to suggest that this error only occurs in SQL Server 2000.  My experience is different.

 

I just got this message:

Too many backup devices specified for backup or restore; only 64 are      allowed. 

after my client did a SQL Server 2005 Backup, then zipped the file, copied it to a CD and mailed it to me.  I copied it to my hard disk and unzipped it and tried using the SQL Server 2005 Restore command.

 

Regardless what tricks I tried, I always got the same message.

 

Any suggestions?

 

Richard

 

Answer 4

Too many backup devices specified for backup or restore; only 64 are allowed. (Microsoft SQL Server, Error: 3205) I am using Sql Server 2005  9.0.1399, I have formatted my pc and after installation of sql server 2005. I am getting this error. Can u please help me how to sort out this problem.

Should I use service pack or any other patches.


***********ITS URGENT BECAUSE I HAVE TO RESTORE LOTS OF BACKUP.............

WAITING FOR POSTIVE RESPONSE.


PANKAJ KIL

Answer 5

Check this thread where similar issue has been discusses already, http://forums.microsoft.com/MSDN/ShowPost.aspx?PostID=2423812&SiteID=1

- Deepak