The Neat Company Forums

Welcome to The Neat Company Forums Sign in | Join | Help
in Search

Manual Database Recovery from Image without having a NR Database Backup Instance

Last post 11-19-2009, 7:24 AM by daspeac. 4 replies.
Sort Posts: Previous Next
  •  09-19-2009, 8:25 PM 6887

    Crying [:'(] Manual Database Recovery from Image without having a NR Database Backup Instance

    Hi all,

    Well, I am in a bit of a predicament, and hoping there's someone out there that can assist. I was running Neatworks 4 (the .exe shows a version of 4.5.288) on a laptop that was running Windows Vista x64. During that time, I had made one backup, but had since made significant additions to my receipts. During that time, I had thankfully created an image using OO DiskImage. Unfortunately, this image will not boot once restored, however, I am able to mount the drive so I can see my drive as it was before the crash. I had not performed a dB backup within neatworks, obviously the easy method of restoring my database is not available, especially since I can't get the image to boot in order to run the dB backup utility.

     So, how can I migrate my data from the image (mounted as an external disk)? Is there a way, either using the SQL Express that is installed with NW, or via a full instance of SQL server, to get the data restored? I have access to SQL expertise that may be able assist me if it's more complicated than I expect. I have hundreds of hours invested in these receipts and I don't want to have to re-live the nightmare I experienced when I had to start from scratch when NR went from ver 3 to ver 4.

     Please help! TIA!!!

     

  •  09-20-2009, 10:12 PM 6890 in reply to 6887

    Re: Manual Database Recovery from Image without having a NR Database Backup Instance

    After restoring the image have you tried reinstalling the OS to get the drive to boot?  This might be the easiest way to get access to the data.

    Always remember to make regular backups.

  •  10-16-2009, 8:48 PM 6958 in reply to 6890

    HELP! Manual Database Recovery from Image without having a NR Database Backup Instance

    The image that I made of the backup failed to boot. I am left with having to manually restore the database without a backup. A friend of mine suggested installing the full version of SQL Server 2005 in order to re-attach to the MDF/LDF files, but I'm wondering if NR folks can provide guidance on this process, and whether it would work or not since I'm not exactly sure how it will work. I just want to get the dB up and running so I can do a proper backup and then start from scratch with a restore.

     Please Help!!

  •  10-30-2009, 6:22 AM 7013 in reply to 6958

    Re: HELP! Manual Database Recovery from Image without having a NR Database Backup Instance

    Update...

    I've tried opening the database in SQL Studio 2005. All databases are accessible, except DB3.mdf? Is there a way to repair an .mdf?

     Please help! I have thousands of receipts and I can't open the damn thing Umbrella

     TIA!

  •  11-19-2009, 7:24 AM 7092 in reply to 7013

    Re: HELP! Manual Database Recovery from Image without having a NR Database Backup Instance

    Hi maxxis, yes, I know how to help. Try the recovery sql server application, it eliminates database errors automatically
View as RSS news feed in XML