Hallo,

I have a problem to migrate my databases from my old computer to my new one.
On both computers I am using MS SQL Server 2005.

To migrate the databases I performed with the Management Studio the
following steps:
1) I have detached a database from the Server of the old computer using the
appropriate task for it.
2) I copied the associated mdf database file onto the new computer.
3) I invoked the append command. In the appropriate dialog I have selected
the new mdf-file and removed the log-file.

When finishing these steps I got the following error message:
Could not find row in sysindexes for database ID 6, object ID 1, index ID 1,
Run DBCC CHECKTABLE on sysindexes.
Could not open new database ‘duevadb_user’. CREATE DATABASE is aborted
(Error 602).

Unfortunately I have no idea why I got this error. Has anyone an idea where
I have made a mistake? Please don’t hesitate to contact me if you need
further information.

Thanks in advance for any .

Best Regards
Kai Siegele

The error suggests that either the source database is corrupt or from a more recent version of SQL
Server. I suggest you go back to the source server and verify the version and possibly also run DBCC
CHECKDB to see that it is clean.

(I prefer to move databases using BACKUP and RESTORE, btw...)

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Problems when migrating databases" <Problems when migrating databases@discussions.microsoft.com>
wrote in message news:0419CED9-FDE2-4DD2-B791-2B67419FB834@microsoft.com...
> Hallo,
>
> I have a problem to migrate my databases from my old computer to my new one.
> On both computers I am using MS SQL Server 2005.
>
> To migrate the databases I performed with the Management Studio the
> following steps:
> 1) I have detached a database from the Server of the old computer using the
> appropriate task for it.
> 2) I copied the associated mdf database file onto the new computer.
> 3) I invoked the append command. In the appropriate dialog I have selected
> the new mdf-file and removed the log-file.
>
> When finishing these steps I got the following error message:
> Could not find row in sysindexes for database ID 6, object ID 1, index ID 1,
> Run DBCC CHECKTABLE on sysindexes.
> Could not open new database ‘duevadb_user’. CREATE DATABASE is aborted
> (Error 602).
>
> Unfortunately I have no idea why I got this error. Has anyone an idea where
> I have made a mistake? Please don’t hesitate to contact me if you need
> further information.
>
> Thanks in advance for any .
>
> Best Regards
> Kai Siegele
>

"Problems when migrating databases" <Problems when migrating
databases@discussions.microsoft.com> wrote in message
news:0419CED9-FDE2-4DD2-B791-2B67419FB834@microsoft.com...
> Hallo,
>
> I have a problem to migrate my databases from my old computer to my new
> one.
> On both computers I am using MS SQL Server 2005.
>
> To migrate the databases I performed with the Management Studio the
> following steps:
> 1) I have detached a database from the Server of the old computer using
> the
> appropriate task for it.
> 2) I copied the associated mdf database file onto the new computer.
> 3) I invoked the append command. In the appropriate dialog I have selected
> the new mdf-file and removed the log-file.
>
> When finishing these steps I got the following error message:
> Could not find row in sysindexes for database ID 6, object ID 1, index ID
> 1,
> Run DBCC CHECKTABLE on sysindexes.
> Could not open new database ‘duevadb_user’. CREATE DATABASE is aborted
> (Error 602).
>
> Unfortunately I have no idea why I got this error. Has anyone an idea
> where
> I have made a mistake? Please don’t hesitate to contact me if you need
> further information.
>
> Thanks in advance for any .
>
> Best Regards
> Kai Siegele
>
Hi

Why did you not copy the ldf file as well?

John

"Problems when migrating databases" <Problems when migrating
databases@discussions.microsoft.com> wrote in message
news:0419CED9-FDE2-4DD2-B791-2B67419FB834@microsoft.com...
> Hallo,
>
> I have a problem to migrate my databases from my old computer to my new
> one.
> On both computers I am using MS SQL Server 2005.
>
> To migrate the databases I performed with the Management Studio the
> following steps:
> 1) I have detached a database from the Server of the old computer using
> the
> appropriate task for it.
> 2) I copied the associated mdf database file onto the new computer.
> 3) I invoked the append command. In the appropriate dialog I have selected
> the new mdf-file and removed the log-file.
>
> When finishing these steps I got the following error message:
> Could not find row in sysindexes for database ID 6, object ID 1, index ID
> 1,
> Run DBCC CHECKTABLE on sysindexes.
> Could not open new database ‘duevadb_user’. CREATE DATABASE is aborted
> (Error 602).
>
> Unfortunately I have no idea why I got this error. Has anyone an idea
> where
> I have made a mistake? Please don’t hesitate to contact me if you need
> further information.
>
> Thanks in advance for any .
>
> Best Regards
> Kai Siegele
>
Hi

Why did you not copy the ldf file as well?

John

Hallo John,

thank you for your reply.

We didn't copy the ldf-file because SQL Server produce a new one and the old
one contains no important information.

Best regards
Kai Siegele

"John Bell" wrote:

>
> "Problems when migrating databases" <Problems when migrating
> databases@discussions.microsoft.com> wrote in message
> news:0419CED9-FDE2-4DD2-B791-2B67419FB834@microsoft.com...
> > Hallo,
> >
> > I have a problem to migrate my databases from my old computer to my new
> > one.
> > On both computers I am using MS SQL Server 2005.
> >
> > To migrate the databases I performed with the Management Studio the
> > following steps:
> > 1) I have detached a database from the Server of the old computer using
> > the
> > appropriate task for it.
> > 2) I copied the associated mdf database file onto the new computer.
> > 3) I invoked the append command. In the appropriate dialog I have selected
> > the new mdf-file and removed the log-file.
> >
> > When finishing these steps I got the following error message:
> > Could not find row in sysindexes for database ID 6, object ID 1, index ID
> > 1,
> > Run DBCC CHECKTABLE on sysindexes.
> > Could not open new database ‘duevadb_user’. CREATE DATABASE is aborted
> > (Error 602).
> >
> > Unfortunately I have no idea why I got this error. Has anyone an idea
> > where
> > I have made a mistake? Please don’t hesitate to contact me if you need
> > further information.
> >
> > Thanks in advance for any .
> >
> > Best Regards
> > Kai Siegele
> >
> Hi
>
> Why did you not copy the ldf file as well?
>
> John
>
>

> We didn't copy the ldf-file because SQL Server produce a new one and the old
> one contains no important information.

Above is a too broad generalization and for many cases not true. SQL Server *might* be able to
create a log file assuming that there's no recovery work to be performed. If you read the
documentation for sp_attach_single_file_db you will find the pre-requisites for SQL server to
re-create a log file for you.

Your case seems different, though. The error seem to suggest that you either try to attach a
database from a more recent version of SQL server (for instance a 2005 file into 2000) or that the
database you try to attach is corrupt.

--
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
http://sqlblog.com/blogs/tibor_karaszi


"Problems when migrating databases" <Problemswhenmigratingdatabases@discussions.micros oft.com> wrote
in message news:B9268BEE-38EF-4D91-B6F0-62614F168191@microsoft.com...
> Hallo John,
>
> thank you for your reply.
>
> We didn't copy the ldf-file because SQL Server produce a new one and the old
> one contains no important information.
>
> Best regards
> Kai Siegele
>
> "John Bell" wrote:
>
>>
>> "Problems when migrating databases" <Problems when migrating
>> databases@discussions.microsoft.com> wrote in message
>> news:0419CED9-FDE2-4DD2-B791-2B67419FB834@microsoft.com...
>> > Hallo,
>> >
>> > I have a problem to migrate my databases from my old computer to my new
>> > one.
>> > On both computers I am using MS SQL Server 2005.
>> >
>> > To migrate the databases I performed with the Management Studio the
>> > following steps:
>> > 1) I have detached a database from the Server of the old computer using
>> > the
>> > appropriate task for it.
>> > 2) I copied the associated mdf database file onto the new computer.
>> > 3) I invoked the append command. In the appropriate dialog I have selected
>> > the new mdf-file and removed the log-file.
>> >
>> > When finishing these steps I got the following error message:
>> > Could not find row in sysindexes for database ID 6, object ID 1, index ID
>> > 1,
>> > Run DBCC CHECKTABLE on sysindexes.
>> > Could not open new database 'duevadb_user'. CREATE DATABASE is aborted
>> > (Error 602).
>> >
>> > Unfortunately I have no idea why I got this error. Has anyone an idea
>> > where
>> > I have made a mistake? Please don't hesitate to contact me if you need
>> > further information.
>> >
>> > Thanks in advance for any .
>> >
>> > Best Regards
>> > Kai Siegele
>> >
>> Hi
>>
>> Why did you not copy the ldf file as well?
>>
>> John
>>
>>