Sunday, February 12, 2012

Attaching a .mdf/.ldf on SQL Server

Trying to attach a SQL Server 2000 database (.mdf with .ldf) onto a fresh
installation of SQL Server 2000.
I get the message :
"Error 602: Could not find row in sysindexes for database ID 7, object ID 1,
index ID 1, Run DBCC CHECKTABLE on sysindexes."
Is there any way to use those files? Unfortunately, I don't have any
backups. Does it matter?I'd put the DB back on the source, run the DBCC, fix what needs to be fixed,
and start over.
"Savvoulidis Iordanis" wrote:
> Trying to attach a SQL Server 2000 database (.mdf with .ldf) onto a fresh
> installation of SQL Server 2000.
> I get the message :
> "Error 602: Could not find row in sysindexes for database ID 7, object ID 1,
> index ID 1, Run DBCC CHECKTABLE on sysindexes."
> Is there any way to use those files? Unfortunately, I don't have any
> backups. Does it matter?
>|||> I get the message :
> "Error 602: Could not find row in sysindexes for database ID 7, object ID
> 1,
> index ID 1, Run DBCC CHECKTABLE on sysindexes."
You can get this error message when trying to attach a database from a
higher version of SQL Server to a lower version. For example, trying to
attach a database from SQL Server 2005 on an instance of SQL Server 2000.
Doesn't sound like this is your case, but I thought I'd mention it just in
case.
--
Gail Erickson [MS]
SQL Server Documentation Team
This posting is provided "AS IS" with no warranties, and confers no rights
Download the latest version of Books Online from
http://technet.microsoft.com/en-us/sqlserver/bb428874.aspx
"Savvoulidis Iordanis" <Savvoulidis Iordanis@.discussions.microsoft.com>
wrote in message news:9E95AAB1-9737-40F7-A940-896F40716630@.microsoft.com...
> Trying to attach a SQL Server 2000 database (.mdf with .ldf) onto a fresh
> installation of SQL Server 2000.
> I get the message :
> "Error 602: Could not find row in sysindexes for database ID 7, object ID
> 1,
> index ID 1, Run DBCC CHECKTABLE on sysindexes."
> Is there any way to use those files? Unfortunately, I don't have any
> backups. Does it matter?
>

No comments:

Post a Comment