Sunday, February 26, 2012

Exception Attaching a DB - SQL 2005

Hey all, trying to attach to a database in SQL Server 2k5 Management Studio and I am getting the following Error:
--
TITLE: Microsoft SQL Server Management Studio

Attach database failed for Server '[MYDBSVRHERE]'. (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 '[MYDBNAMEHERE]'. 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

--

Does anybody have ANY idea about how to fix? Is this a permissions thing?
Thanks in advance!

So... I am a complete idiot!. I spent a DAY trying to figure out the problem. In the end, I had not installed SQL2k5. I had installed the tools, but they were connecting to SQL 2k.

thanks,

Dork|||Glad to hear you "fixed" the problem!|||

Hi,

my server have SQL Server 2000. I detach a database in this server and copy to my laptop.

I attact that database to SQL Server 2005 and do so many things on it.

some days after, i copy this file from my laptop to my server i try to attact it to SQL server 2000.

the same prolem appear.!!!

Does anyone know HOW TO fix? Thanks!

No comments:

Post a Comment