Groups | Blog | Home
all groups > sql server new users > june 2006 >

sql server new users : cann't restore or attach database


Sam
6/29/2006 10:37:57 PM
i try to copy a database to a laptop
when i use RESTORE i get the error: "Too many backup devices specified for
backup or restore; only 64 are allowed"
when i use ATTACH i get the error: "Could not find row in sysindexes for
database ID ..... Run DBCC CHECKTABLE on sysindexes. "

so how can i mannade it?

thanks

Steen Persson (DK)
6/30/2006 12:00:00 AM
[quoted text, click to view]
Hi

It sounds like you are trying to restore/attach a SQL2005 database on a
SQL2000 instance.


--
Regards
Steen Schlüter Persson
Sam
6/30/2006 12:00:00 AM
first i tried to restore/attach a from SQL2005 to SQL2005 and i recieved =
the same errors
then i removed the SQL2005 from the laptop and instaled SQL2000 and i =
recieved the same errors

there is an msde version instaled that i didn't removed

[quoted text, click to view]
Sam wrote:=20
i try to copy a database to a laptop
when i use RESTORE i get the error: "Too many backup devices specified =
for=20
backup or restore; only 64 are allowed"
when i use ATTACH i get the error: "Could not find row in sysindexes for =

database ID ..... Run DBCC CHECKTABLE on sysindexes. "

so how can i mannade it?

thanks=20


Hi

It sounds like you are trying to restore/attach a SQL2005 database on =
a SQL2000 instance.


--=20
Regards
Steen Schl=FCter Persson
AddThis Social Bookmark Button