Prev: GUID In Table
Next: Problem with transactionnal replication
From: SandraDee on 14 Apr 2010 23:40
I am trying to attach a database from SQL Express 2005 to SQL Server 2005 and
I am getting the error:

Attach database failed for Server 'xxxxxx'.

An exception occurred while executing a Transact-SQL Statement or batch.
Could not find row in sysindexes for database ID 6, object ID 1. Run DBCC
CHECKTABLE on sysindexes.
Could not open database 'xxxxxx.mdf'. Create DATABASE is aborted. (Microsoft
SQL Server, Error: 602)

I am not sure how to Run DBCC CHECKTABLE.

My project is halted until I get this resolved. Any help is appreciated.

From: Helmut Woess on 15 Apr 2010 01:03
Am Thu, 15 Apr 2010 03:40:37 GMT schrieb SandraDee:
....
> I am trying to attach a database from SQL Express 2005 to SQL Server 2005 and
....
> My project is halted until I get this resolved. Any help is appreciated.

Make a backup from SQLExpress database, create in SQLServer an empty
database with the same name and then restore backup.

bye,
Helmut
From: Tibor Karaszi on 15 Apr 2010 03:14
The database you try seems to be corrupt. On the source server (where the
database came from), open a query window and execute:
DBCC CHECKDB(dbname) WITH NO_INFOMSGS

See if you have any error messages. If you do, then it is likely that best
action is to restore that database from a healthy backup, but it depends a
bit on what error you see. If CHECKDB do not return any errors, then I
suggest you instead move the database using BACKUP and RESTORE (but you
don't need to create a database on the destination server in order to
restore, the RESTORE command will do that for you) - or re-try the
detach/attach operation of you don't like BACKUP/RESTORE.

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



"SandraDee" <u59367(a)uwe> wrote in message news:a68c79c4f1747(a)uwe...
> I am trying to attach a database from SQL Express 2005 to SQL Server 2005
> and
> I am getting the error:
>
> Attach database failed for Server 'xxxxxx'.
>
> An exception occurred while executing a Transact-SQL Statement or batch.
> Could not find row in sysindexes for database ID 6, object ID 1. Run
> DBCC
> CHECKTABLE on sysindexes.
> Could not open database 'xxxxxx.mdf'. Create DATABASE is aborted.
> (Microsoft
> SQL Server, Error: 602)
>
> I am not sure how to Run DBCC CHECKTABLE.
>
> My project is halted until I get this resolved. Any help is appreciated.
>
 | 
Pages: 1
Prev: GUID In Table
Next: Problem with transactionnal replication