Install on 64 bit cluster-SQL BAckup 5.1.0.2781

• 
  Exploring a bit further -
  I changed the REG Key ( \\HKLM\WOW6432Node\RedGate\SQLBackup\BackupSettingsGlobal\(LOCAL) on my DB server to reflect the correct install path-
  c:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL)
  
  Still getting the error- because the 'data.sdf' wasn't installed on the server.
  
  What gives ?

  randyj September 23, 2007 17:17

  - 0 +
• 
  Trying to run various operations with this (semi) install..
  Latest (and of course... most critical) is this
  
  
  master..sqlbackup N'-SQL "RESTORE DATABASE [xxxxxx]
  FROM DISK = ''\\10.1.3.32\Backup\Database\FromFP\FULL_xxxxxx_20070923_132938.sqb''
  WITH RECOVERY,
  REPLACE,
  PASSWORD = ''xxxxxxxx''"'
  
  Which gets me this reply ....
  
  Warning 400: Failed to initialize local data store: The path is not valid. Check the directory for the database. [Path=C:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL)\data.sdf]
  
  
  No gui, no SQL command line, no love

  randyj September 23, 2007 17:40

  - 0 +
• 
  Was the 'C:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL)' folder created? If not, please check if the SQL Backup Agent service startup user has rights to create folders/files in the 'C:\Program Files (x86)' folder.

  petey September 23, 2007 22:23

  - 0 +
• 
  Peter -
  The 'C:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL)' folder was created, and several files were copied:
  SQBCoreService.exe
  SQLBackupC.exe
  unins000.dat
  unins000.exe
  zlib1.dll
  no 'data.sdf' file, however.
  
  as well as a subfolder (x64) with one file:
  xp_sqlbackup.dll

  randyj September 24, 2007 12:15

  - 0 +
• 
  When the SQL Backup Agent service first starts, it attemps to create a SQL Server Compact Edition database, to store the backup/restore history data. On a clustered instance, it will try to create this file in the <drive>\Program Files\Red Gate\SQL Backup\Data\<instance name> folder, where <drive> represents the drive where the SQL Server data files are stored. This allows different nodes in the cluster to access the same database.
  
  This path is then stored in the registry, in the DataPath value under HKEY_LOCAL_MACHINE\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\.
  
  Could you please check if there is a DataPath entry in the registry, under the above node? Could you also please check if there is a data.sdf file in the folder described above?
  
  Thanks.

  petey September 25, 2007 04:05

  - 0 +
• 
  Pete -
  See the first two messages in this thread -
  When I initially installed, I was getting the error:
  
  
  "Failed to initialize local data store: The path is not valid. check the directory for the database. [Path=c:\Program Files\Red Gate\SQL Backup\Data\(LOCAL)\data.sdf"
  
  The program actually installed on my DB server into the 'Program Files (x86)' folder.
  I changed the REG Key ( \\HKLM\WOW6432Node\RedGate\SQLBackup\BackupSettingsGlobal\(LOCAL) on my DB server to reflect the correct install path-
  c:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL).
  
  There are several files installed there, but NO data.sdf

  randyj September 25, 2007 12:24

  - 0 +
• 
  Okjay -
  Still dead in the water.
  I've unistalled, and reinstalled. THe GUI opens, and when I attempt to register the Default instance on the virtual server, I get the error I detailed initially.
  "A problem was encountered whilst communicating with the server
  
  'Failed to initialize local data store: The path is not valid. check the directory for the database. [Path=c:\Program Files\Red Gate\SQL Backup\Data\(LOCAL)\data.sdf"
  
  First - yes... it is an invalid path. The software was installed into the
  c:\Program Files (x86)\Red Gate\SQL Backup directory
  Second - it is REALLY an invalid because no such file as 'data.sdf' exists.
  
  So - I'm stuck. I've just sent an email to support asking for assistance, but I've had better luckj in the forums, so I'll try once more.
  
  Thanks !

  randyj September 26, 2007 16:45

  - 0 +
• 
  Could you please check the DataPath value under the registry node HKLM\Wow6432Node\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>? If it exists, what is its value?
  
  Could you also please check if the folder <drive>\Program Files (x86)\Red Gate\SQL Backup\Data\<instance name> folder exists, where <drive> represents the drive where the SQL Server data files are stored?
  
  Thanks.

  petey September 27, 2007 05:29

  - 0 +
• 
  After my reinstall -
  Registry node HKLM\Wow6432Node\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<LOCAL> DataPath key exists. It's value is:
  c:\Program files\Red Gate\SQL Backup\Data\(LOCAL)
  
  However, no such Path was created on my machine.
  
  Note that prior to doing the reinstallation, I had deleted the Registry Node 'HKLM\Wow6432Node\Software\Red Gate' and everything underneath it.
  
  
  In fact, during the reinstall, I chose to install on one of the cluster's shared drives, r:\. The program was installed on the shared drive at r:\Red Gate\SQL Backup\(LOCAL), but still... no 'data.sdf' file.

  randyj September 27, 2007 11:02

  - 0 +
• 
  Was there a C:\Program files (x86)\Red Gate\SQL Backup\Data\(LOCAL) folder created?
  
  I'm surprised at why SQL Backup chose the C:\ drive to store the local daa store, given that this is a clustered instance. In the registry node for SQL Server, what are the values for DefaultData, SQLDataRoot and SQLPath? The last 2 would be found under the \Setup subnode.
  
  Thanks.

  petey September 27, 2007 11:59

  - 0 +
• 
  Peter -
  The 'C:\Program Files (x86)\Red Gate\SQL Backup\Data\(LOCAL)' folder was created, and several files were copied:
  SQBCoreService.exe
  SQLBackupC.exe
  unins000.dat
  unins000.exe
  zlib1.dll
  no 'data.sdf' file, however.
  
  as well as a subfolder (x64) with one file:
  xp_sqlbackup.dll
  
  Note that when asked by the installer, I requested the program be installed on 'R:\', a shared cluster drive.
  Nothing was installed to the 'R:\' drive.
  
  
  Registry node HKLM\Wow6432Node\Software\Red Gate\SQL Backup\BackupSettingsGlobal\<LOCAL> DataPath key exists. It's value is:
  c:\Program files\Red Gate\SQL Backup\Data\(LOCAL)
  
  SQLDataRoot Key is :
  R:\Microsoft SQL Server\MSSQL.1\MSSQL
  
  SQLPath Key is:
  C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL
  
  No 'DefaultData' Key exists, on either of two seperate, similar installations

  randyj October 03, 2007 21:32

  - 0 +
• 
  Try the following:
  
  - remove the DataPath entry from HKLM\Software\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)
  
  - bounce the SQL Backup Agent service
  
  What is the new DataPath value in the registry?
  
  Thanks.

  petey October 04, 2007 04:42

  - 0 +
• 
  Presumably, you're referring to :
  the DataPath entry from HKLM\Wow6432Node\Software\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL) ?
  
  Removing thvalue from this Key, and restarting the Backup service results in the value being re-written as:
  
  'C:\Program Files\Red Gate\SQL Backup\Data\(LOCAL)'

  randyj October 04, 2007 13:03

  - 0 +
• 
  Okay -
  Would this be helped by walking through an uninstall / reinstall together ?
  
  It's been more than a week without any meaningful assistance or suggestions, and I REALLY don't have much more time to spend on this. I need these servers up and running. Given that compressed / encrypted backups are a MUST for my environment, I will need to begin looking for other tools.
  
  I opened an 'official' support case (F0007044) on this a week ago, I've been participating here as frequently as I can, and I'm no closer to working services than I was.
  
  What more can I do ?

  randyj October 05, 2007 12:01

  - 0 +

Add comment

Please sign in to leave a comment.