Networks

Ask something
Question Locked

SQL 2005 Error when restoring backup

0 helpful
3 replies

by mellow52

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Hi,

I currently have a sql 2005 server and installed sql 2005 onto another server that already has sql2000. I do not want to remove the sql2000. When I try and recover a backed up data base from the dedicated sql2005 server to the sql2005 server that is on the same server as 2000 I get the following error:

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

Any guidance will be appreciated.

thanks

3 replies

by tony hopkinson

Either way worth checking the compatibility mode on the 2005 databases.

If it thinks they came from 2k it will be 80, 2005 expects 90

This discussion is closed to new replies.