problem error no 9003  
Author Message
mikeindo





PostPosted: Sat Aug 04 10:31:49 CDT 2007 Top

SQL Server >> 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



SQL Server241  
 
 
Russell





PostPosted: Sat Aug 04 10:31:49 CDT 2007 Top

SQL Server >> problem error no 9003 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


> 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


>