Script to attach MDF without LDF under SQL2000

USE MASTER

GO

SP_CONFIGURE 'ALLOW UPDATES',1 RECONFIGURE WITH OVERRIDE

GO

UPDATE SYSDATABASES SET STATUS =32768 WHERE NAME='db_NAME'

Go

sp_dboption 'db_NAME', 'single user', 'true'

Go

DBCC CHECKDB('db_NAME')

Go

update sysdatabases set status =28 where name='db_NAME'

Go

sp_configure 'allow updates', 0 reconfigure with override

Go

sp_dboption 'db_NAME', 'single user', 'false'

Go

Seagate 7200.12 ‘SIM ERROR’ Firmware Fault

The symptoms of ‘SIM Error’ firmware fault from hard drives belong to Seagate 7200.12 family are:

1. Hard drive status keeps BUSY forever after switching on;

2. In the serial command line, it outputs (when PCB is attached to hard drive):

SIM Error 3005
No HOST FIS-ReadyStatusFlags 2002A1A5
ASCII Diag mode

3. In the serial command line, it outputs (when PCB is detached from hard drive):

No HOST FIS-ReadyStatusFlags 2002A1A5

To use the conventional method of fixing a ‘BUSY and LBA=0’ 7200.11 hard drive, it outputs:

No HOST FIS-ReadyStatusFlags 2002A1A5
ASCII Diag mode
F3 T>/2
F3 2>Z
Spin Down Complete
Elapsed Time 6.015 secs
F3 2>
ASCII Diag mode
F3 T>/2
F3 2>U
HighPowerMode
ExecuteSpinRequest
Spin Up Complete
Elapsed Time 3.624 secs
F3 2>/1
F3 1>N1
Init SMART Fail

The initialization of SMART module is failed even though the hard drive passes the Spin up and Spin down operation. To solve this problem, instead of doing N1 to clear the SMART after comand U, we use command m0 first.

(P) SATA Reset

SIM Error 3005
No HOST FIS-ReadyStatusFlags 2002A1A5
ASCII Diag mode

F3 T>/2

F3 2>Z

Spin Down Complete
Elapsed Time 6.035 secs
F3 2>U

HighPowerMode
ExecuteSpinRequest

Spin Up Complete
Elapsed Time 3.573 secs
F3 2>/

F3 T>m0,2,2,,,,,22
Max Wr Retries = 00, Max Rd Retries = 00, Max ECC T-Level = 16, Max Certify Rewr
ite Retries = not supported

User Partition Format Successful - Elapsed Time 0 mins 00 secs

F3 T>/1

F3 1>N1

Clear SMART is completed.
F3 1>
Rst 0x08M
(P) SATA Reset

Written by: Zijian Xie (R&D Manager, MSc,BEng)