1 Topic by Monticola

  • Monticola
  • Member
  • Offline
  • Registered: 06-04-2012
  • Posts: 48

Topic: Restoring R6 backup copy when rebuilding system

Yet again I need to rebuild my Recorder system after having to restore everything on the PC, including Windows 7.
(I've been here before in general terms - this is my 3rd re-installation after getting a new (& duff) PC).  But there the similarity ends.

I have used the documentation for Recorder 6 standalone version 4.
I've (re-)installed MS SQL Server 2008,  then (re-)installed Recorder 6 from the download, v 6.17.2.251. 
I've rebuilt the indexes, and done the 2 dictionary upgrades (had also tried without doing this).
My version is now as it was when I did my last back-up, but the backup doesn't do anything (but no error messages either).

I see it may not be possible to use the "restore" option to bring it back with a Windows 7 installation, but I don't know how to use MS Tools to do this for me.

I just hope this is the problem ...!

Where can I find instructions on how to do this.
Thanks
Nigel

2 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Restoring R6 backup copy when rebuilding system

Assuming you do have a backup file available and  have SQL Server 2008 Management tools  then proceed as follows.

Open Management Studioa and connect to your Sql Server 2008 instance.
Expand out databases and you should see NBNdata
Right click on this then select tasks/Restore/Database - this shoould bring up the Restore database window
Under 'Specify the Source an Location ..... '   change to 'From Device'
Use the Browse (...) to open the Specify Backup Window
Make sure Backup Media is set to file and click on Add
You should now be able to find your backup file (NBNData.bak)
Choose this which will take you back to the Specify Backup window where you can click on Ok.

If you need more detailed instruction let me know.

Mike Weideli

MikeWeideli's Website

3 Reply by Monticola

  • Monticola
  • Member
  • Offline
  • Registered: 06-04-2012
  • Posts: 48

Re: Restoring R6 backup copy when rebuilding system

I have obviously done something incorrectly, or there is something else amiss somewhere.

I opened the MS SQL Server Management Studio.
The input panel only offers 2 options for Server Type: Database Engine, or SQL Server Compact.  I chose the latter.
I browsed the C drive for the required database file, and selected the Recorder 6\Database\nbndata.mdb.
I then clicked the Connect button, and an error panel appeared:

Cannot connect to ...(database file path)
Additional information - this is not a valid SQL Server Database file or this file version is not supported by current SQL server compact engine
(SQL server compact ADO.NET data provider)

4 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Restoring R6 backup copy when rebuilding system

You should  choose database engine.  This should give you drop down for the Server name which should show the SQL instance (probably only one).  Choose Windows Authentication and then connect.

Mike Weideli

MikeWeideli's Website

5 Reply by Monticola

  • Monticola
  • Member
  • Offline
  • Registered: 06-04-2012
  • Posts: 48

Re: Restoring R6 backup copy when rebuilding system

I forgot to mention before that I had tried that, and other things, and assumed they was wrong because they didn't work..

Server type of "database engine" gives 2 options for server name.
One is "local", and the other is "browse for more".
Choosing that gives selection of local or network servers.
No "SQL instance" is offered anywhere as far as I can see.

6 Reply by MikeWeideli

  • MikeWeideli
  • Administrator
  • Offline
  • From: Littlefield Consultancy
  • Registered: 05-07-2006
  • Posts: 2,645

Re: Restoring R6 backup copy when rebuilding system

You will have chosen a name for the instance when you installed SQL Server and use this when installing Recorder 6.   Probably the easiest way of finding this is to use regedit.    Type 'regedit' in  Search Program and Files. Regedit  should then be displayed at the top of the list of programs. Click on this and navigate to  HKey Local machine/Software/Dorset Software/Recorder 6. On the right hand side you see server name and to the right of this in the data column is name of the instance which Recorder is using. Note this down  and type it into the  Server Name box when connecting.  On a 64 bit machine it in  HKey Local machine/Software/WOW6432/Dorset Software/Recorder 6 - or search for Dorset Sofware.

Mike Weideli

MikeWeideli's Website

7 Reply by Monticola

  • Monticola
  • Member
  • Offline
  • Registered: 06-04-2012
  • Posts: 48

Re: Restoring R6 backup copy when rebuilding system

I have a 64-bit machine, so it was the latter option (I was beginning to feel desperate when I looked for "Dorset" in the software list and it wasn't there!).  I found my way there eventually, though it was rather more labyrinthine than I had expected.
AND IT ***** WORKED!  WONDERFUL.

I feel rather like the legendary monkey, who might (without help) have accidentally hit on the solution after a few million years of randomly striking keys.

Thanks Mike.
Nigel

8 Reply by lupus

  • lupus
  • New member
  • Offline
  • Registered: 19-01-2013
  • Posts: 1

Re: Restoring R6 backup copy when rebuilding system

Make sure Backup Media is set to file and click on Add
You should now be able to find your backup file

lupus's Website

9 Reply by Monticola

  • Monticola
  • Member
  • Offline
  • Registered: 06-04-2012
  • Posts: 48

Re: Restoring R6 backup copy when rebuilding system

There's no problem now: it's all fixed.  I found the backup file and restored it.