error 3205

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!

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?

|||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.