Impossible to attach Adventureworks

Question

Post reply

Impossible to attach Adventureworks

Dinu E Anastasiu

Ten Centuries

Points: 1177
More actions
March 18, 2006 at 1:37 pm

#112050

I just installed SQL 2005 and I tried (repeatedly) to attach Adventureworks; it fails displaying the Message Box below.
I run DBCC Checktable and I got the following reply, with no errors:
DBCC results for 'sysindexes'.
There are 100 rows in 4 pages for object 'sysindexes'.
DBCC execution completed. If DBCC printed error messages, contact your system administrator.
The two links mentioned in the Message Box are helpless.
Many thanks for your help,
Dinu
Message Box
==============================================================
TITLE: Microsoft SQL Server Management Studio
------------------------------
Attach database failed for Server xxxx. (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 5, 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

Viewing 15 posts - 1 through 15 (of 33 total)

You must be logged in to reply to this topic. Login to reply

raj-247939 SSCertifiable Points: 5999 More actions · Answer 1

raj-247939

SSCertifiable

Points: 5999

March 19, 2006 at 8:51 pm

#627495

Dear ,

Can u pls paste the code here.

from

Killer

Dinu E Anastasiu Ten Centuries Points: 1177 More actions · Answer 2

Dinu E Anastasiu

Ten Centuries

Points: 1177

March 19, 2006 at 11:39 pm

#627502

Sorry, which code do you mean?

Thanks,

Dinu

Joseph Mulhall SSCarpal Tunnel Points: 4672 More actions · Answer 3

Joseph Mulhall

SSCarpal Tunnel

Points: 4672

March 20, 2006 at 1:47 am

#627513

THe attach code.

Dinu E Anastasiu Ten Centuries Points: 1177 More actions · Answer 4

I used the SQL Server Management Studio Attach function not code.

Joseph Mulhall SSCarpal Tunnel Points: 4672 More actions · Answer 5

Edit and run this:

CREATE DATABASE AdventureWorks

ON (FILENAME = 'c:\whateveryourpathishere\AdventureWorks.mdf')

FOR ATTACH

acloudy Grasshopper Points: 17 More actions · Answer 6

Veteran: I have tried it \,this same error:

Msg 1813, Level 16, State 2, Line 1

Can not open 'AdventureWorks'?CREATE DATABASE ????

Msg 602, Level 21, State 50, Line 1

??? sysindexes ?????? ID 12 ??? ID 1 ??? ID 1 ??????? sysindexes ?? DBCC CHECKTABLE?

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 12, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes

Ronald E. Van Aken Grasshopper Points: 11 More actions · Answer 7

I get the same error:

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'AdventureWorks'. CREATE DATABASE is aborted.

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

I've run DBCC CHECKTABLE and everything looks good.

DBCC results for 'sysindexes'.

There are 102 rows in 4 pages for object 'sysindexes'.

DBCC execution completed. If DBCC printed error messages, contact your system administrator.

I'm comparing Crystal Reports to MS Report Services, and I'd like to walk throught the tutorials, but the AdventureWorks DB is required.

fnmansuri SSC-Addicted Points: 400 More actions · Answer 8

Hi Experts!!!

I am also facing the same problem. I tried to attach "AdventureWorks" db using many alternate ways but unfortunatelly all failed.

It would be really great to get solution from someone in this group.

If anyone have prooved solution, please post it here.

Appreciate your help.

Regards,

Fakruddin Mansuri

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 9

Have you tried by executing the install script (instawdb.sql)...

Script for AdventureWorks OLTP should be located in C:\Program Files\Microsoft SQL Server\90\Tools\Samples\AdventureWorks OLTP

--Ramesh

Tommy Bollhofer SSChampion Points: 14940 More actions · Answer 10

Codeplex now maintains the AdventureWorks sample databases. Are you using the latest rev (for SP2a)? i.e. http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004

Tommy

Follow @sqlscribe

@fracionero Right there with Babe Points: 737 More actions · Answer 11

You only need add a sentence for attach_rebuild_log

With this script you can attach AdventureWorks in the same folder where master exists.

DECLARE @data_path nvarchar(256);

DECLARE @db nvarchar(50);

DECLARE @filename nvarchar(100);

SET @data_path = (SELECT SUBSTRING(physical_name, 1, CHARINDEX(N'master.mdf', LOWER(physical_name)) - 1)

FROM master.sys.master_files

WHERE database_id = 1 AND file_id = 1);

set @db='AdventureWorks'

set @filename= @db+ '_data.mdf'

exec ('CREATE DATABASE ' + @db + '

ON (FILENAME = '''+ @data_path + @filename + ')

FOR ATTACH_REBUILD_LOG');

GO

Francisco Racionero
twitter: @fracionero

fnmansuri SSC-Addicted Points: 400 More actions · Answer 12

Hi Ramesh,

Thanks for your quick response.

No, I haven't tried with install script (instawdb.sql). Infact this script is not available on my system. Can you please suggest me how should I proceed further? Where can I get the script file.

Thanks for your time.

--Fakruddin

Ramesh Saive SSC-Insane Points: 24275 More actions · Answer 13

You can use the link what Tommy has provided...

--Ramesh

fnmansuri SSC-Addicted Points: 400 More actions · Answer 14

Thanks Ramesh, Francisco Racionero and Tommy for your time.

I tried all your suggested option but still I am not able to have adverntureWorks db on my system.

As Francisco suggested, I tried running the scrip but it says "Invalid object name 'master.sys.master_files". I used master database.

Then I tried running the script like this

"CREATE DATABASE AdventureWorks

ON (FILENAME = 'D:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\Data\AdventureWorks_Data.mdf')

FOR ATTACH_REBUILD_LOG"

But it still gives error.

As Ramesh and Tommy suggeted, I downloaded the latest msi file from the location "http://www.codeplex.com/MSFTDBProdSamples/Release/ProjectReleases.aspx?ReleaseId=4004" and ran the setup. It gave me .mdf and .ldf files. Then I tried to attach the same using Enterprise Manager. but it failed with the error message as below

Msg 1813, Level 16, State 2, Line 1

Could not open new database 'AdventureWorks_Data'. CREATE DATABASE is aborted.

Msg 602, Level 21, State 50, Line 1

Could not find row in sysindexes for database ID 9, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.

Please advise.

Once again thanks a lot for your time.

Regards,

Fakruddin