Problem in attaching database

Hi all,
I am facing a problem during attaching a database (.mdf and .ldf files are copied fro another server). the message I am getting as follows:

messages was from 'Microsoft SQL Server Management Studio Express':

===================================

Attach database failed for Server 'CTPL-1'. (Microsoft.SqlServer.Express.Smo)

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

----------
Program Location:

at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files, String owner)
at Microsoft.SqlServer.Management.SqlManagerUI.Attach DatabaseData.PrimaryFile.Attach()
at Microsoft.SqlServer.Management.SqlManagerUI.Attach Database.SendDataToServer()

===================================

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

----------
Program Location:

at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(StringCollection sqlCommands, ExecutionTypes executionType)
at Microsoft.SqlServer.Management.Smo.ExecutionManage r.ExecuteNonQuery(StringCollection queries)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabaseWorker(String name, StringCollection files, String owner, AttachOptions attachOptions)
at Microsoft.SqlServer.Management.Smo.Server.AttachDa tabase(String name, StringCollection files, String owner)

===================================

Could not find row in sysindexes for database ID 8, object ID 1, index ID 1. Run DBCC CHECKTABLE on sysindexes.
Could not open new database 'mci'. CREATE DATABASE is aborted. (.Net SqlClient Data Provider)

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

----------
Server Name: (local)
Error Number: 602
Severity: 21
State: 50
Line Number: 1

----------
Program Location:

at System.Data.SqlClient.SqlConnection.OnError(SqlExc eption exception, Boolean breakConnection)
at System.Data.SqlClient.SqlInternalConnection.OnErro r(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndW arning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
at System.Data.SqlClient.SqlCommand.RunExecuteNonQuer yTds(String methodName, Boolean async)
at System.Data.SqlClient.SqlCommand.InternalExecuteNo nQuery(DbAsyncResult result, String methodName, Boolean sendToPipe)
at System.Data.SqlClient.SqlCommand.ExecuteNonQuery()
at Microsoft.SqlServer.Management.Common.ServerConnec tion.ExecuteNonQuery(String sqlCommand, ExecutionTypes executionType)

===============================================


********************************

the followings are the command and mesage from Query Analyzer:

*****************************************

command:

-- =============================================
-- Attach database via sp_attach_db
-- =============================================
EXECUTE sp_attach_db @.dbname = N'mci',
@.filename1 = N'd:\ifgl\database\mci.mdf',
@.filename2 = N'd:\ifgl\database\mci_log.ldf'
GO

*****************************************

message:

Server: 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.

Connection Broken

*******************************************

I am new to MS SQL Server and unable to solve the problem. Can anyone help me in this metter.

Thanks in advance.Can anybody give some quick solution to the above problem?|||I am guessing that you just copied the mdf/ldf without actually detaching first. In that case the mdf and ldf will be invalid.

I would suggest restoring from a backup rather than doing the detach/attach thing.

problem error no 9003

in sqlserver 2000 i am properly deteched the database. in attached
time i am face the problem error no 9003 but mdf and log are present.
i am traie to this script.
Create Database with exact name and mdf-ldf files (sobmmainserverdep
i am create)
2. Stop MSSQLSERVER service, replace created mdf file with original
one
3. Start MSSQLSERVER service, the database will be in Suspend mode
4. From Query Analyzer (QA) execute script
use master
go
sp_configure 'allow updates', 1
reconfigure with override
go
5. From QA execute script
update sysdatabases set status= 32768 where name = '<db_name>'
ex("db_name =sobmmainserverdep")
6. Restart MSSQLSERVER service, the database will be in Emergency mode
7. Rebuild Log. From QA execute script
DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
a
message - Warning: The log for database '<db_name>' has been rebuilt.
ex.(db_name is sobmmainserverdep , new log file is
sobmmainserverdep_log).
8. From QA execute script
Use master
go
sp_configure 'allow updates', 0
Go
9. Clear from Enterprise Manager on database properties options tab
Restrict
access checkbox
in 7 possition i am not rebuild the log file. and they provied the
error like "Device activation error. The physical file name
'sobmmainserverdep_log' may be incorrect.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
"
so plez help i am attacehed the database in properly.
mail me
shishu05@.gmail.com
shishu_05@.rediffmail.comshishu,
You apparently are copying over only the mdf to replace the existing mdf.
You should also copy the ldf to replace the existing ldf.
If you really get stuck, this undocument, unsupported, not for the timid
procedure from Jasper Smith saved me once upon a time.
http://www.tech-archive.net/Archive...04-03/3026.html
RLF
"love shishu" <shishu05@.gmail.com> wrote in message
news:1186240282.891142.286540@.q3g2000prf.googlegroups.com...
> in sqlserver 2000 i am properly deteched the database. in attached
> time i am face the problem error no 9003 but mdf and log are present.
> i am traie to this script.
> Create Database with exact name and mdf-ldf files (sobmmainserverdep
> i am create)
> 2. Stop MSSQLSERVER service, replace created mdf file with original
> one
> 3. Start MSSQLSERVER service, the database will be in Suspend mode
> 4. From Query Analyzer (QA) execute script
> use master
> go
> sp_configure 'allow updates', 1
> reconfigure with override
> go
> 5. From QA execute script
> update sysdatabases set status= 32768 where name = '<db_name>'
> ex("db_name =sobmmainserverdep")
> 6. Restart MSSQLSERVER service, the database will be in Emergency mode
> 7. Rebuild Log. From QA execute script
> DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
> a
> message - Warning: The log for database '<db_name>' has been rebuilt.
> ex.(db_name is sobmmainserverdep , new log file is
> sobmmainserverdep_log).
>
> 8. From QA execute script
> Use master
> go
> sp_configure 'allow updates', 0
> Go
> 9. Clear from Enterprise Manager on database properties options tab
> Restrict
> access checkbox
> in 7 possition i am not rebuild the log file. and they provied the
> error like "Device activation error. The physical file name
> 'sobmmainserverdep_log' may be incorrect.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> "
> so plez help i am attacehed the database in properly.
> mail me
> shishu05@.gmail.com
> shishu_05@.rediffmail.com
>

problem error no 9003

in sqlserver 2000 i am properly deteched the database. in attached
time i am face the problem error no 9003 but mdf and log are present.
i am traie to this script.
Create Database with exact name and mdf-ldf files (sobmmainserverdep
i am create)
2. Stop MSSQLSERVER service, replace created mdf file with original
one
3. Start MSSQLSERVER service, the database will be in Suspend mode
4. From Query Analyzer (QA) execute script
use master
go
sp_configure 'allow updates', 1
reconfigure with override
go
5. From QA execute script
update sysdatabases set status= 32768 where name = '<db_name>'
ex("db_name =sobmmainserverdep")
6. Restart MSSQLSERVER service, the database will be in Emergency mode
7. Rebuild Log. From QA execute script
DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
a
message - Warning: The log for database '<db_name>' has been rebuilt.
ex.(db_name is sobmmainserverdep , new log file is
sobmmainserverdep_log).
8. From QA execute script
Use master
go
sp_configure 'allow updates', 0
Go
9. Clear from Enterprise Manager on database properties options tab
Restrict
access checkbox
in 7 possition i am not rebuild the log file. and they provied the
error like "Device activation error. The physical file name
'sobmmainserverdep_log' may be incorrect.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
"
so plez help i am attacehed the database in properly.
mail me
shishu05@.gmail.com
shishu_05@.rediffmail.comshishu,
You apparently are copying over only the mdf to replace the existing mdf.
You should also copy the ldf to replace the existing ldf.
If you really get stuck, this undocument, unsupported, not for the timid
procedure from Jasper Smith saved me once upon a time.
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.server/2004-03/3026.html
RLF
"love shishu" <shishu05@.gmail.com> wrote in message
news:1186240282.891142.286540@.q3g2000prf.googlegroups.com...
> in sqlserver 2000 i am properly deteched the database. in attached
> time i am face the problem error no 9003 but mdf and log are present.
> i am traie to this script.
> Create Database with exact name and mdf-ldf files (sobmmainserverdep
> i am create)
> 2. Stop MSSQLSERVER service, replace created mdf file with original
> one
> 3. Start MSSQLSERVER service, the database will be in Suspend mode
> 4. From Query Analyzer (QA) execute script
> use master
> go
> sp_configure 'allow updates', 1
> reconfigure with override
> go
> 5. From QA execute script
> update sysdatabases set status= 32768 where name = '<db_name>'
> ex("db_name =sobmmainserverdep")
> 6. Restart MSSQLSERVER service, the database will be in Emergency mode
> 7. Rebuild Log. From QA execute script
> DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
> a
> message - Warning: The log for database '<db_name>' has been rebuilt.
> ex.(db_name is sobmmainserverdep , new log file is
> sobmmainserverdep_log).
>
> 8. From QA execute script
> Use master
> go
> sp_configure 'allow updates', 0
> Go
> 9. Clear from Enterprise Manager on database properties options tab
> Restrict
> access checkbox
> in 7 possition i am not rebuild the log file. and they provied the
> error like "Device activation error. The physical file name
> 'sobmmainserverdep_log' may be incorrect.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> "
> so plez help i am attacehed the database in properly.
> mail me
> shishu05@.gmail.com
> shishu_05@.rediffmail.com
>

problem error no 9003

in sqlserver 2000 i am properly deteched the database. in attached
time i am face the problem error no 9003 but mdf and log are present.
i am traie to this script.
Create Database with exact name and mdf-ldf files (sobmmainserverdep
i am create)
2. Stop MSSQLSERVER service, replace created mdf file with original
one
3. Start MSSQLSERVER service, the database will be in Suspend mode
4. From Query Analyzer (QA) execute script
use master
go
sp_configure 'allow updates', 1
reconfigure with override
go
5. From QA execute script
update sysdatabases set status= 32768 where name = '<db_name>'
ex("db_name =sobmmainserverdep")
6. Restart MSSQLSERVER service, the database will be in Emergency mode
7. Rebuild Log. From QA execute script
DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
a
message - Warning: The log for database '<db_name>' has been rebuilt.
ex.(db_name is sobmmainserverdep , new log file is
sobmmainserverdep_log).
8. From QA execute script
Use master
go
sp_configure 'allow updates', 0
Go
9. Clear from Enterprise Manager on database properties options tab
Restrict
access checkbox
in 7 possition i am not rebuild the log file. and they provied the
error like "Device activation error. The physical file name
'sobmmainserverdep_log' may be incorrect.
DBCC execution completed. If DBCC printed error messages, contact your
system administrator.
"
so plez help i am attacehed the database in properly.
mail me
[email]shishu_05@.rediffmail.com" rel="nofollow">shishu05@.gmail.com[/email]
[email]shishu_05@.rediffmail.com
shishu,
You apparently are copying over only the mdf to replace the existing mdf.
You should also copy the ldf to replace the existing ldf.
If you really get stuck, this undocument, unsupported, not for the timid
procedure from Jasper Smith saved me once upon a time.
http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.server/2004-03/3026.html
RLF
"love shishu" <shishu05@.gmail.com> wrote in message
news:1186240282.891142.286540@.q3g2000prf.googlegro ups.com...
> in sqlserver 2000 i am properly deteched the database. in attached
> time i am face the problem error no 9003 but mdf and log are present.
> i am traie to this script.
> Create Database with exact name and mdf-ldf files (sobmmainserverdep
> i am create)
> 2. Stop MSSQLSERVER service, replace created mdf file with original
> one
> 3. Start MSSQLSERVER service, the database will be in Suspend mode
> 4. From Query Analyzer (QA) execute script
> use master
> go
> sp_configure 'allow updates', 1
> reconfigure with override
> go
> 5. From QA execute script
> update sysdatabases set status= 32768 where name = '<db_name>'
> ex("db_name =sobmmainserverdep")
> 6. Restart MSSQLSERVER service, the database will be in Emergency mode
> 7. Rebuild Log. From QA execute script
> DBCC REBUILD_LOG('<db_name>', '<full name to new log file>'). You got
> a
> message - Warning: The log for database '<db_name>' has been rebuilt.
> ex.(db_name is sobmmainserverdep , new log file is
> sobmmainserverdep_log).
>
> 8. From QA execute script
> Use master
> go
> sp_configure 'allow updates', 0
> Go
> 9. Clear from Enterprise Manager on database properties options tab
> Restrict
> access checkbox
> in 7 possition i am not rebuild the log file. and they provied the
> error like "Device activation error. The physical file name
> 'sobmmainserverdep_log' may be incorrect.
> DBCC execution completed. If DBCC printed error messages, contact your
> system administrator.
> "
> so plez help i am attacehed the database in properly.
> mail me
> shishu05@.gmail.com
> shishu_05@.rediffmail.com
>