Unable to attach database (backward compatibility

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2005 Forums

Other SQL Server Topics (2005)

Unable to attach database (backward compatibility

Author

Topic

vamsimahi
Starting Member

29 Posts

Posted - 2008-07-06 : 17:23:25

Hi,

I installed SQL server 2000 and SQL 2000 SP4.
Than I installed SQL Server 2005. But when I am trying to attach the AdventureWorks Sample database, I am getting the following error:

TITLE: Microsoft SQL Server Management Studio
------------------------------

An error occurred when attaching the database(s). Click the hyperlink in the Message column for details.

------------------------------
BUTTONS:

OK
------------------------------
------------------------------
TITLE: Microsoft SQL Server Management Studio
------------------------------

Attach database failed for Server 'VAMSI'. (Microsoft.SqlServer.Smo)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&ProdVer=9.00.1399.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.FailedOperationExceptionText&EvtID=Attach+database+Server&LinkId=20476

------------------------------
ADDITIONAL INFORMATION:

An exception occurred while executing a Transact-SQL statement or batch. (Microsoft.SqlServer.ConnectionInfo)

------------------------------

Could not find row in sysindexes for database ID 7, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

For help, click: http://go.microsoft.com/fwlink?ProdName=Microsoft+SQL+Server&EvtSrc=MSSQLServer&EvtID=602&LinkId=20476

------------------------------
BUTTONS:

OK
------------------------------

Can anyone please help me, how to resolve this issue.

rmiao
Master Smack Fu Yak Hacker

7266 Posts

Posted - 2008-07-06 : 18:22:54

Attatch to which instance? Where did you get AdventureWorks?