1 Topic by Tony Witts

  • Tony Witts
  • Member
  • Offline
  • From: Kent & Medway BRC
  • Registered: 08-04-2009
  • Posts: 21

Topic: Unable to restore database backup

Hi,
I've just installed R6 on a Windows 10 laptop wth SQL server 2014. Everything has gone smoothly, but when I try to restore the last back up from my old Win XP machine R6 falls over. This is the exception message in the log file:
exception message : Directory lookup for the file "c:\Program Files\Microsoft SQLServer\MSSQL.1\MSSQL\DATA\nbndata_data_log.LDF" failed with the operating system error 3(The system cannot find the path specified.).
However the log file can be found here:
C:\Program Files\Microsoft SQL Server\MSSQL12.SQLEXPRESS\MSSQL\DATA
Can I fix this?

Full error log file attached
Best wishes
Tony

2 Reply by MikeWeideli

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

Re: Unable to restore database backup

Seems to be similar to a  problem happening elsewhere.  Which version of SQL Server were you with the XP machine.  Were you trying to restore though Recorder 6 or using Management Studio ?

Mike Weideli

MikeWeideli's Website

3 Reply by Tony Witts

  • Tony Witts
  • Member
  • Offline
  • From: Kent & Medway BRC
  • Registered: 08-04-2009
  • Posts: 21

Re: Unable to restore database backup

Hi Mike,
I think it was SQL Server express 2008.
However i have now been shown how to restore the database through the management studio. This reported that it completed successfully, though now R6 won't log me into the database giving me the  EOleException: Cannot open database "NBNData" requested by the login. The login failed" message.
One step forward.....
I've looked through the threads on here and checked that the SQL Server services are running; one out of the four different ones was running so i started Sql Server browser as recommended. I still get the same error though.

4 Reply by MikeWeideli

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

Re: Unable to restore database backup

Try running the SQL in the download at
http://forums.nbn.org.uk/viewtopic.php?id=6271

Before you did the restore was R6 running ?

Mike Weideli

MikeWeideli's Website

5 Reply by Tony Witts

  • Tony Witts
  • Member
  • Offline
  • From: Kent & Medway BRC
  • Registered: 08-04-2009
  • Posts: 21

Re: Unable to restore database backup

Hi Mike.
yes R6 was working before, just empty
Fab! that worked! What did it do?
Thanks so much!
Tony

6 Reply by MikeWeideli

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

Re: Unable to restore database backup

I must admit I don't fully understand this aspect of SQL Server.  The following is the best I can do

When you move from one  SQL Server instance to another the mapping of the database logins to the users can get disrupted creating orphaned users. Orphaned users in SQL Server occur when a database user is based on a login in the master database, but the login no longer exists in master. This can occur when the login is deleted, or when the database is moved to another server where the login does not exist. The SQL  finds the  orphaned users, and remaps them to logins.

Mike Weideli

MikeWeideli's Website