error while attaching database

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

General SQL Server Forums

New to SQL Server Programming

error while attaching database

Author

Topic

jim_cool
Starting Member

43 Posts

Posted - 2006-07-19 : 00:16:08

hi all
i am working on sql server 2005
When i am trying to attach database in my server i am getting following error. Plz help me to fix this error.
the error as as follows :

Attach database failed for Server 'myserver'. (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 10, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'ReportServer'. CREATE DATABASE is aborted. (Microsoft SQL Server, Error: 602)

KenW
Constraint Violating Yak Guru

391 Posts

Posted - 2006-07-19 : 16:18:18

jim_cool,

So did you do what the error message told you (run DBCC CHECKTABLE on sysindexes)? If so, what was the result?

Ken

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2006-07-19 : 21:23:53

you might want to post this in the "Data Corruption Issues" forum.

-ec

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources