Can not open SQL Backup GUI after installing

• 

  Hello Harold,

  Thanks for your inquiry and sorry to hear about your issue with Redgate SQL Backup.

  Normally, you should be able to install the SQL Backup GUI on any supported Windows system. It's only the SQL Backup Server Components that need to be installed on an instance that has SQL Server.

  Do you have the same issue if you try uninstalling and re-installing the SQL Backup GUI as an admin using the installer available below?

  https://download.red-gate.com/checkforupdates/SQLBackup/SQLBackup_10.1.28.2479.exe

   

  Thanks!

  squigley September 20, 2024 22:06

  - 0 +
• 

  hbuckner said:
  

  I just installed SQL backup to test it and the application will not open. I installed it on Windows 11 and Server 2019 and both have the same error. 
  
  Update**
  
  I just tried installing this on a windows Server 2019 with SQL Server installed and it did open. SQL Server was not listed as a pre requisite so I am not sure what my client workstations may be missing to run the GUI. It has the .net that was listed.   
  **
  
  
  Errors from the error log. 
  

  Faulting application name: RedGate.SQLBackup.UI.exe, version: 10.1.28.2479, time stamp: 0xeffbd369

  Faulting module name: KERNELBASE.dll, version: 10.0.22621.4111, time stamp: 0xb2651143

  Exception code: 0xe0434352

  Fault offset: 0x0014a892

  Faulting process id: 0x0x6648

  Faulting application start time: 0x0x1DB0AB056247212

  Faulting application path: C:\Program Files (x86)\Red Gate\SQL Backup 10\RedGate.SQLBackup.UI.exe

  Faulting module path: C:\Windows\System32\KERNELBASE.dll

  Report Id: d24ee8f4-ad87-4658-910c-8f39729fddea

  Faulting package full name: 

  Faulting package-relative application ID: 
  
  
  

  Application: RedGate.SQLBackup.UI.exe

  Framework Version: v4.0.30319

  Description: The process was terminated due to an unhandled exception.

  Exception Info: System.IO.FileLoadException

     at System.SpanHelpers.IndexOf(Char ByRef, Char, Int32)

     at System.MemoryExtensions.IndexOf[[System.Char, mscorlib, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089]](System.ReadOnlySpan`1<Char>, Char)

     at System.Resources.Extensions.TypeNameComparer.Equals(System.String, System.String)

     at System.Resources.Extensions.DeserializingResourceReader.ValidateReaderType(System.String)

     at System.Resources.Extensions.DeserializingResourceReader._ReadResources()

     at System.Resources.Extensions.DeserializingResourceReader.ReadResources()

     at System.Resources.Extensions.DeserializingResourceReader..ctor(System.IO.Stream)

  
  

  Exception Info: System.Reflection.TargetInvocationException

     at System.RuntimeMethodHandle.InvokeMethod(System.Object, System.Object[], System.Signature, Boolean)

     at System.Reflection.RuntimeConstructorInfo.Invoke(System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo)

     at System.RuntimeType.CreateInstanceImpl(System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo, System.Object[], System.Threading.StackCrawlMark ByRef)

     at System.Activator.CreateInstance(System.Type, System.Reflection.BindingFlags, System.Reflection.Binder, System.Object[], System.Globalization.CultureInfo, System.Object[])

     at System.Activator.CreateInstance(System.Type, System.Object[])

     at System.Resources.ManifestBasedResourceGroveler.CreateResourceSet(System.IO.Stream, System.Reflection.Assembly)

     at System.Resources.ManifestBasedResourceGroveler.GrovelForResourceSet(System.Globalization.CultureInfo, System.Collections.Generic.Dictionary`2<System.String,System.Resources.ResourceSet>, Boolean, Boolean, System.Threading.StackCrawlMark ByRef)

     at System.Resources.ResourceManager.InternalGetResourceSet(System.Globalization.CultureInfo, Boolean, Boolean, System.Threading.StackCrawlMark ByRef)

     at vn pro
   System.Resources.ResourceManager.InternalGetResourceSet(System.Globalization.CultureInfo, Boolean, Boolean)

     at System.Resources.ResourceManager.GetObject(System.String, System.Globalization.CultureInfo, Boolean)

     at System.Resources.ResourceManager.GetObject(System.String, System.Globalization.CultureInfo)

     at RedGate.SQLBackup.UI.Properties.Resources.get_Splash_1___Timeline_Color_Code()

     at RedGate.SQLBackup.UI.SplashForm.InitializeComponent()

     at RedGate.SQLBackup.UI.SplashForm..ctor()

     at RedGate.SQLBackup.UI.Program.ShowSplash()

     at System.Threading.ThreadHelper.ThreadStart_Context(System.Object)

     at System.Threading.ExecutionContext.RunInternal(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

     at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object, Boolean)

     at System.Threading.ExecutionContext.Run(System.Threading.ExecutionContext, System.Threading.ContextCallback, System.Object)

     at System.Threading.ThreadHelper.ThreadStart()

  
  

  It looks like the issue might be related to missing dependencies or incorrect environment setup on the client workstations. Based on the error logs, the problem could be tied to the .NET Framework or other prerequisites not being correctly installed. Here are a few steps you can try:

  1. Verify .NET Framework Version: Ensure the client workstations have the correct version of the .NET Framework (v4.0.30319 or higher). You might want to reinstall or repair it.

  2. Install SQL Server Components: Although SQL Server wasn't listed as a prerequisite, some SQL-related components may be needed for the application to run. You can try installing SQL Server Management Studio (SSMS) or any SQL Server tools.

  3. Check Permissions: Ensure that the application has sufficient permissions to access the necessary system files (e.g., KERNELBASE.dll). Running the application as an administrator may help.

  4. Compatibility Mode: Try running the application in compatibility mode for older versions of Windows.

  5. Update Windows: Ensure that Windows 11 and Server 2019 are fully updated, as missing updates can sometimes cause issues with certain DLLs or system files.

  If the issue persists, checking with RedGate support might provide more specific guidance on missing dependencies.

  fakhru01 October 05, 2024 10:40

  - 0 +
• 
  Support provided fix for a file (RedGate.SQLBackup.UI.exe.config) that needed updated. It is now working.

  hbuckner October 05, 2024 11:48

  - 0 +
• 
  Glad to hear it's working much better Harold!
  Future releases of Redgate SQL Backup should have this fix integrated by default.
  Have a great week!

  squigley October 07, 2024 20:16

  - 0 +
• 
  Thanks@fakhru this definitely helped me alot.

  talharizwaan October 24, 2024 09:30

  - 0 +

Add comment

Please sign in to leave a comment.