Scsi Hard Disk

Dynamics GP Files Recovery after the Server Hard Disk Crash

Let's assume that you got into unpleasant situation, where you do not have resent backup of your SQL Server databases, and your RAID disks failed to the level where recovery should be given to the hands of the professional data recovery firm.  This is really not an ideal situation, but there is still some hope, that portion of the failed hard drives could be recovered.  In this small paper we would like to give you the directions on what needs to be recovered as the top priority.  First we will give you the scenario, where we assume that you are on MS SQL Server 2008, 2005, 2000, or 7.0: versions 2010, 10.0, 9.0, 8.0, 7.5, 7.0, 6.0, 5.5, 5.0 and then we will look at the older versions of Great Plains Dynamics on Pervasive SQL 2000/Btrieve and Accounting for DOS, Windows or Mac:

1. SQL Server based version.  Here the files to recover have .MDF extension.  The system database is GPS DynamicsDat.mdf.  You should have at least one company where Dynamics part of the file name is replaced by your company DB abbreviation.  There are chances, that you have more than one company.  In the scenario, where you company abbreviation is One the file to look for is GPSOneDat.mdf

2. Additional files that are good candidates for recovery, but not required.  First one is Reports.dic – where your modified reports, such as SOP Blank Invoice form with logo are hosted.  Second one is probably from FRx Financial Reporting – what is critical for FRx recovery is Sysdata folder and the file to look for is FRxrpts.f32.  The third candidate is likelyto be Integration Manager metadata file: IM.MDB

3. Redeployment technologies.  In the case of FRx or IM you have to simply recover the files and call your Great Plains consultant for further instructions.  When you are lucky to recover SQL Server DB files – the next step is to install Microsoft SQL Server on the new server and try to reattach DB files.  Review the instructions to sp_attach_db procedure (probably single file version: sp_attach_db_single_file, if you have no luck to restore log file – but log file is optional).  If you were able to attach databases, the next step is to call your consultant on transferring user logins and passwords, modifying Dynamics.set file from the user workstations side to reflect new path reporting dictionaries

4. Older versions on Pervasive SQL 2000/Btrieve or Ctree.  Here you need to look for BTR (Btrieve or its successor Pervasive SQL 2000) or DAT file extensions.  These files typically reside in the Dynamics folder on the server.  If you open this folder you should see System and companies subfolders.  When you are redeploying the data on the new computer, please be sure that you are doing it on the 32 bit version of the Microsoft Windows 2003/2008 server or 32 bit Vista, Windows XP or Windows 7.  You will need Pervasive SQL 2000 installation CD (with registration key diskette)

5. Great Plains DOS, Windows or Mac Accounting versions 9.5, 9.2 and earlier.  Here you have Btrieve database platform, which could be deployed on Pervasive SQL 2000 32 bit version.  You should try to concentrate on the recovery of the GPS folder of your crashed server.  GPA nowadays is usually in inquiry only mode, meaning that you do not have to place it on the server-client environment, you can just deploy it on Intel Atom processor based Netbook (WindowsXP 32 bit).  Please, note that GPA is not compatible with Windows 7, Vista or XP 64 bit version, as this application installation media was issued back in earlier 2000, where 64 bit processing was not known.  We saw multiple situations, where we were instructing GPA recovering customers to purchase Windows XP 32 bit computer, and they simply went to BestBuy or TigerDirect and purchased the cheapest Windows 7 on AMD or Intel processor platform

6. Some advices.  It is very unlikely that previous consulting organization left you without SQL Server Agent file based or tape backup (Arcserve, Seagate or another brand).  Also RAID 5 SCSI hard disks set is recoverable, assuming that the only one HD failed.  We encourage you to talk to your IT manager or Networking consultant, maybe they are not aware about the simple way to restore status quo

About the Author

Andrew Karasev is Great Plains Certified Master, MVP, help@efaru.com 1-866-304-3265, 1-269-605-4904. He is also the initiator of eFaru project http://www.efaru.com and founder of Alba Spectrum information space

36GB SCSI IBM 80pin SCA2 Hard Disk Drive ECE32075 $198.4 36GB SCSI IBM 80pin SCA2 Hard Disk Drive ECE32075

36GB Scsi HP 10000RPM Ultra320 Hard Disk A657160001 A657160001 $170 36GB Scsi HP 10000RPM Ultra320 Hard Disk A657160001 A657160001

72GB SCSI Cisco MP 8106 Hard Disk MP8106HD $415.85 72GB SCSI Cisco MP 8106 Hard Disk MP8106HD

Used Akai Dr8 Hard Disk Recorder 1Gb Scsi $49.99 In Store Used USED AKAI DR8 HARD DISK RECORDER 1GB SCSI

9.1GB SCSI Compaq Wide ULTRA3 Hard Disk 10KRPM Hot Plug 180732001 $75.51 9.1GB SCSI Compaq Wide ULTRA3 Hard Disk 10KRPM Hot Plug 180732001

72GB HP 15000RPM 3.5" Hot Swap SCSI(SAS) Hard Disk Drive With Tray 384852B21 384852-B21 $81.75 72GB HP 15000RPM 3.5" Hot Swap SCSI(SAS) Hard Disk Drive With Tray 384852B21 384852-B21

Seagate ST3146807LW 146GB 10000 rpm 68pin SCSI Ultra320 server hard disk drive, 1 yr warranty $113.68 Seagate ST3146807LW 146GB 10000 rpm 68pin SCSI Ultra320 internal Server Computer Hard Disk Drives, high quality, fast ship

347708-B22 146GB 3.5inch Ultra320 15000rpm SCSI server hard disk drives kits $143.16 347708-B22 SCSI 146GB 80pin 3.5inch 15K Hot-swap Ultra320 15000rpm internal Server Computer Hard Disk Drives kits, high quality

286716-B22 146GB 3.5inch Ultra320 10K SCSI server hard disk drives kits for DL380G3 DL380G4 ML350G4 ML370G3 $114 286716-B22 SCSI 1460GB 80pin 3.5inch 10K Hot-swap Ultra320 10000rpm internal Server Computer Hard Disk Drives kits, high quality

350964-B22 300GB 3.5inch Ultra320 10K SCSI server hard disk drives kits $189.47 350694-B22 SCSI 300GB 80pin 3.5inch 10K Hot-swap Ultra320 10000rpm internal Server Computer Hard Disk Drives kits, fast ship!

286714-B22 72GB 3.5inch Ultra320 10000rpm SCSI server hard disk drives kits $84.21 286714-B22 SCSI 72GB 80pin 3.5inch 10K Hot-swap Ultra320 10000rpm internal Server Computer Hard Disk Drives kits, high quality

286713-B22 36GB 3.5inch Ultra320 10000rpm SCSI 8M server hard disk drives kits $73.68 286713-B22 SCSI 36GB 80pin 3.5inch 10K Hot-swap Ultra320 10000rpm internal Server Computer Hard Disk Drives kits, high quality!

Hard Disk 20sc $92.4 High Quality Content by WIKIPEDIA articles The Apple Hard Disk 20SC (not to be confused with the Apple Macintosh Hard Disk 20, the first hard drive manufactured by Apple exclusively for the original Macintosh floppy disk drive port interface) was Apples first SCSI based hard drive for the Apple II family as well as the Macintosh and other third party computers using an industry standard SCSI interface.Released in September 1986 along with the Apple IIGS (which required an optional SCSI interface card), it debuted over 9 months after the introduction of the Macintosh Plus, the first to include Apples SCSI interface. It was a welcome addition at considerably faster data transfer rates (up to 1.25 megabytes per second) over its much slower predecessors, the Hard Disk 20 (500 Kilobits per second) and ProFile (which could only be used with the Macintosh XL). Author: Surhone, Lambert M./ Tennoe, Mariam T./ Henssonow, Susan F. Binding Type: Paperback Number of Pages: 128 Publication Date: 2010/08/17 Language: English Dimensions: 6.00 x 9.02 x 0.30 inches

IBM Ultra320 SCSI Disk Drive Backplane 39J1695 $158.48 IBM Ultra320 SCSI Disk Drive Backplane 39J1695

2.1GB Scsi Seagate Hard Drive $14.8 2.1GB Scsi Seagate Hard Drive

760MB Micropolis SCSI Hard Drive $231.53 760MB Micropolis SCSI Hard Drive

9.1GB SCSI Compaq Hard Drive Ultra3 10K SCSI HotPlug 142671-B21 $26.25 9.1GB SCSI Compaq Hard Drive Ultra3 10K SCSI HotPlug 142671-B21

hard drive - 36 GB - SCSI $283.99 Axiom - Hard drive - 36 GB - hot-swap - SCSI - 10000 rpm

hard drive - 146 GB - SCSI $518.99 Axiom - Hard drive - 146 GB - hot-swap - SCSI - 15000 rpm

hard drive - 73 GB - SCSI $331.99 Axiom - Hard drive - 73 GB - hot-swap - SCSI - 10000 rpm

2.1G SCSI Quantum Hard Drive VP32210 $59.77 2.1G SCSI Quantum Hard Drive VP32210

338MB Micropolis 5.25in SCSI Hard Drive 1578 $105.58 338MB Micropolis 5.25in SCSI Hard Drive 1578

286775-B22 - Hp 18.20 Gb 3.5 inch Internal Hard Drive - Ultra320 Scsi - 15000 Rpm - Hot Pluggable $117.44 hp/compaq Ultra320 Scsi Hard Drive Provides a Maximum Data Transfer Rate of 320 Mb/s - Twice The Rate of Ultra3 Systems. This Universal Hard Disk Drive Provides The Ability to Hot Plug Between Various HP Ultra320, Ultra3 And Ultra2 Scsi Platforms. This Drive is Intended For Use in Today's Demanding, Data-critical Enterprise Environments. [DP8783] UNSPC: 43201803

26K5679 - Ibm 73.40 Gb 3.5 inch Internal Hard Drive - Ultra320 Scsi - 15000 Rpm - 8 Mb Buffer $356.37 this 15,000 Rpm Scsi Hard Disk Drive (hdd) Option Helps Satisfy Midrange to Entry-level Data-storage Applications For Ibm Eserver Xseries Systems And Ibm Eserver Bladecenter. This Non-hot-swap Hdd is Engineered to Support The Entry to Midrange Level Enterprise Server Applications. [DW4275] UNSPC: 43201803

32P0724 - Ibm 73.40 Gb 3.5 inch Internal Hard Drive - 1 Pack - Ultra320 Scsi - 10000 Rpm $311.17 Double Your Throughput in Select Xseries Servers With The Next Generation of High-speed Ultra320 Scsi Hard Disk Drives (hdds). Ultra320 Scsi Drives Provide Top-of-the-line Performance For Business-critical, Disk-intensive Applications Such as E-business, Transaction Processing, Data Mining And Data Warehousing. ultra320 Scsi Technology Combines Interface Data Transfer Rates of up to 320mbps, Reduced Overhead And Enhanced Flow Control to Help Deliver Dramatic Performance Gains. Improved Diagnostics And Data Protection Help Reduce Downtime. For Even Greater Reliability, You Can Create High-perfomance Raid Arrays. Simply Connect Your Drives to Either an Onboard Ultra320 Scsi Controller With Integrated Mirroring Capabilities or an Ibm Serveraid-5i Controller, Available on Select Xseries Servers. [DR9877] UNSPC: 43201803

IBM 07N9428 Hitachi Ultrastar 73GB SCSI Hard Drive (Refurbished) $50.91 Introducing the sixth generation of IBM Ultrastar 10,000 rpm disk drive. This drive feature more powerful processors and read-write channels to excel in server-class environments.Product description: Hitachi 07N9428 73GB SCSI hard driveDevice type: Internal hard driveCapacity: 73.4 GBBuffer size: 8 MBHeads (physical): 6Spindle speed: 10,000 rpmAverage seek time: 4.7 msData transfer rate: 320 MBpsConnector: 80 pin Centronics (SCA-2)Interface type: Ultra320 SCSICondition: Mnf. RefurbishedType of package: BulkPackage includes: Hard driveDimensions: 4 inches wide x 5.7 inches deep x 1 inch highWeight: 1.8 poundsManufacturer Part Number: 07N9428This high-quality item has been factory refurbished. Please click on the icon above for more information on quality factory-reconditioned merchandise.

ACARD AEC7720UW Ultra SCSI Wide to IDE Bridge $203.58 The ACARD Ultra Wide SCSIIDE bridge is dedicated conversion kit which converts the low cost / high performance ATA HD to high performance SCSI (Small Computer System Interface). As it supports IDE (Integrated Device Electronics) hard drives which can be easily attached to SCSI bus. With ACARD microcontroller core builtin it provides more flexibility and stability for highly exploring application. The ACARD SCSIIDE bridge supports most platforms and/or Operation System including PC Windows 98 / ME / NT / 2000 / XP / Windows Server 2003 Linux and Mac platforms. The ACARD SCSIIDE bridge has no disk capacity limitation a user can install a 160 GB or even higher capacity of hard disk in the future. Features. A general purpose SCSItoIDE device converter. Higher system I/O performance. Creates new SCSI devices in economic cost. Windows Server 2003 Support. Specifications. Ultra Wide SCSI interface for up to 40MB/sec data transfer rate Supports DMA 66/100/133 hard drives Onboard flash ROM for easy firmware upgrade Selectable SCS ID from 0 to 15 Full Ultra Wide SCSI target features support

90P1306 - Ibm 146.80 Gb 3.5 inch Internal Hard Drive - Ultra320 Scsi - 10000 Rpm - 8 Mb Buffer - Hot Swappable $382.2 double Your Throughput in Select Ibm Eserver Xseries Servers With The Next Generation of High-speed Ultra320 Scsi Hard Disk Drive, Now With The New Ultra-slim Tray Form Factor. Ultra320 Scsi Drive Provides Top-of-the-line Performance For Business-critical, Disk-intensive Applications Such as E-business, Transaction Processing, Data Mining And Data Warehousing. [DR9815] UNSPC: 43201803

32P0734 - Ibm 36.40 Gb 3.5 inch Internal Hard Drive - 1 Pack - Ultra320 Scsi - 15000 Rpm - 8 Mb Buffer - Hot Swappable $214.31 increase Your Throughput in Select Xseries Servers With The Next Generation of High-speed Ultra320 Scsi Hard Disk Drives (hdds). Ultra320 Scsi Drives Provide Top-of-the-line Performance For Business-critical, Disk-intensive Applications Such as E-business, Transaction Processing, Data Maining And Data Warehousing. [DR9849] UNSPC: 43201803

This entry was posted on Tuesday, August 5th, 2008 at 10:49 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.