Sql Backup And FTP

Welcome Guest Search | Active Topics | Log In | Register
New Topic Post Reply
SQLBackupAndFTP v6 Beta is ready for testing. Find a bug and get a Prof version for free! Options · View
ruslan
#1 Posted : Tuesday, July 05, 2011 8:24:36 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Edit: Beta testing is now closed - v 6 is live.

If you'd like to test SQLBackupAndFTP v6 Beta, you can download it here [Link Removed]. If you are the first person to find a certain bug and post about it in this topic - we will give you a Professional license for FREE. Note that while we appreciate if you find misspellings in the program, they do not count as bugs. Also if a problem is derived from a bug (Problem1 > Problem2 > Problem3), it is still a single bug. If you are posting as a Guest, don't forget to put your name at the end.
ruslan
#2 Posted : Tuesday, July 05, 2011 8:29:11 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
To start: WebLog button on the face of the form should lead to http://sqlbackupandftp.com/weblog/, not http://sqlbackupandftp.com/weblog/?demo
fuser
#3 Posted : Tuesday, July 05, 2011 8:40:48 PM Quote
Rank: Newbie

Groups: Registered

Joined: 1/20/2011
Posts: 4
- Installer issue
The NSIS installer isn't recording a product version to the registry (source). It will be an issue to tell via remote tools what servers require updates.

- Uninstaller issue(s)
1) There's a file left behind in install directory not removed via NSIS SbfService.exe stopping from the proper clean removal of the install directory.
2) Registry key HKEY_LOCAL_MACHINE\SOFTWARE\Pranas.NET is left
3) .jobx files are still left registered to SQLBackupAndFTP

- Cosmetic issue
Typo in this posting subject "Fing" a bug ;)


- Ongoing application issue
Still having the same crashes on the Windows Server 2008 R2 server listed here. Here's the crash from the beta:
Problem signature:
Problem Event Name: APPCRASH
Application Name: SQLBackupAndFTP.exe
Application Version: 6.0.5.0
Application Timestamp: 4e13264a
Fault Module Name: USER32.dll
Fault Module Version: 6.1.7601.17514
Fault Module Timestamp: 4ce7c9f1
Exception Code: c00000fd
Exception Offset: 0000000000013b73
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033
ruslan
#4 Posted : Wednesday, July 06, 2011 8:58:54 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
[quote=ruslan]To start: WebLog button on the face of the form should lead to http://sqlbackupandftp.com/weblog/, not http://sqlbackupandftp.com/weblog/?demo[/quote]
It is actually a feature: free users are being directed to weblog demo, while paid - to their own weblog
Correction: now it always goes to own weblog.
mikeshilov
#5 Posted : Wednesday, July 06, 2011 9:10:47 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
fuser wrote:
- Installer issue
The NSIS installer isn't recording a product version to the registry (source). It will be an issue to tell via remote tools what servers require updates.


It a minor thing, but thank for pointing this out

fuser wrote:
- Uninstaller issue(s)
1) There's a file left behind in install directory not removed via NSIS SbfService.exe stopping from the proper clean removal of the install directory.
2) Registry key HKEY_LOCAL_MACHINE\SOFTWARE\Pranas.NET is left
3) .jobx files are still left registered to SQLBackupAndFTP

2) we leave this information because this make reinstallation process run smoothly
1,3) thank you for reporting, we'll check it

fuser wrote:

- Cosmetic issue
Typo in this posting subject "Fing" a bug ;)


thank you, fixed ;)

fuser wrote:

- Ongoing application issue
Still having the same crashes on the Windows Server 2008 R2 server listed here. Here's the crash from the beta:
Problem signature:
Problem Event Name: APPCRASH
Application Name: SQLBackupAndFTP.exe
Application Version: 6.0.5.0
Application Timestamp: 4e13264a
Fault Module Name: USER32.dll
Fault Module Version: 6.1.7601.17514
Fault Module Timestamp: 4ce7c9f1
Exception Code: c00000fd
Exception Offset: 0000000000013b73
OS Version: 6.1.7601.2.1.0.272.7
Locale ID: 1033


It seems this happens on your system only. We havn't received such reports from other users. So it's hard for us to reproduce and fix this problem.

Are you still able to test the application?
Birama
#6 Posted : Wednesday, July 06, 2011 3:33:50 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
ee the end of this message for details on invoking
just-in-time (JIT) debugging instead of this dialog box.

************** Exception Text **************
System.Data.SqlClient.SqlException: A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: Named Pipes Provider, error: 40 - Could not open a connection to SQL Server)
at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
at System.Data.SqlClient.TdsParser.Connect(ServerInfo serverInfo, SqlInternalConnectionTds connHandler, Boolean ignoreSniOpenTimeout, Int64 timerExpire, Boolean encrypt, Boolean trustServerCert, Boolean integratedSecurity, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
at System.Data.SqlClient.SqlConnection.Open()
at a.o.a(SqlServerInfo A_0, List`1 A_1)
at a.d.a()
at a.d.f(Object A_0, EventArgs A_1)
at System.Windows.Forms.NumericUpDown.OnValueChanged(EventArgs e)
at System.Windows.Forms.NumericUpDown.set_Value(Decimal value)
at System.Windows.Forms.NumericUpDown.DownButton()
at System.Windows.Forms.UpDownBase.OnUpDown(Object source, UpDownEventArgs e)
at System.Windows.Forms.UpDownBase.UpDownButtons.OnUpDown(UpDownEventArgs upevent)
at System.Windows.Forms.UpDownBase.UpDownButtons.BeginButtonPress(MouseEventArgs e)
at System.Windows.Forms.UpDownBase.UpDownButtons.OnMouseDown(MouseEventArgs e)
at System.Windows.Forms.Control.WmMouseDown(Message& m, MouseButtons button, Int32 clicks)
at System.Windows.Forms.Control.WndProc(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.OnMessage(Message& m)
at System.Windows.Forms.Control.ControlNativeWindow.WndProc(Message& m)
at System.Windows.Forms.NativeWindow.Callback(IntPtr hWnd, Int32 msg, IntPtr wparam, IntPtr lparam)


************** Loaded Assemblies **************
mscorlib
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
CodeBase: file:///c:/WINDOWS/Microsoft.NET/Framework/v2.0.50727/mscorlib.dll

SQLBackupAndFTP
Assembly Version: 6.0.6.29201
Win32 Version: 6.0.6.0
CodeBase: file:///C:/Program%20Files/Pranas.NET/SQLBackupAndFTP/SQLBackupAndFTP.exe

Xceed.Zip
Assembly Version: 4.2.10175.16000
Win32 Version: 4.2.10175.16000
CodeBase: file:///C:/Program%20Files/Pranas.NET/SQLBackupAndFTP/Xceed.Zip.DLL

System.Windows.Forms
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3623 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Windows.Forms/2.0.0.0__b77a5c561934e089/System.Windows.Forms.dll

System
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3620 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

System.Drawing
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Drawing/2.0.0.0__b03f5f7f11d50a3a/System.Drawing.dll

Xceed.Compression
Assembly Version: 4.2.10175.16000
Win32 Version: 4.2.10175.16000
CodeBase: file:///C:/Program%20Files/Pranas.NET/SQLBackupAndFTP/Xceed.Compression.DLL

Xceed.FileSystem
Assembly Version: 4.2.10175.16000
Win32 Version: 4.2.10175.16000
CodeBase: file:///C:/Program%20Files/Pranas.NET/SQLBackupAndFTP/Xceed.FileSystem.DLL

System.Xml
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3082 (QFE.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Xml/2.0.0.0__b77a5c561934e089/System.Xml.dll

System.Configuration
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System.Configuration/2.0.0.0__b03f5f7f11d50a3a/System.Configuration.dll

dc0quvi3
Assembly Version: 6.0.6.29201
Win32 Version: 2.0.50727.3620 (GDR.050727-3600)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/System/2.0.0.0__b77a5c561934e089/System.dll

System.Data
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Data/2.0.0.0__b77a5c561934e089/System.Data.dll

System.Transactions
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.Transactions/2.0.0.0__b77a5c561934e089/System.Transactions.dll

System.EnterpriseServices
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_32/System.EnterpriseServices/2.0.0.0__b03f5f7f11d50a3a/System.EnterpriseServices.dll

Dart.PowerTCP.Ftp
Assembly Version: 3.0.5.1
Win32 Version: 3.0.5.1
CodeBase: file:///C:/Program%20Files/Pranas.NET/SQLBackupAndFTP/Dart.PowerTCP.Ftp.DLL

Accessibility
Assembly Version: 2.0.0.0
Win32 Version: 2.0.50727.3053 (netfxsp.050727-3000)
CodeBase: file:///C:/WINDOWS/assembly/GAC_MSIL/Accessibility/2.0.0.0__b03f5f7f11d50a3a/Accessibility.dll


************** JIT Debugging **************
To enable just-in-time (JIT) debugging, the .config file for this
application or computer (machine.config) must have the
jitDebugging value set in the system.windows.forms section.
The application must also be compiled with debugging
enabled.

For example:

<configuration>
<system.windows.forms jitDebugging="true" />
</configuration>

When JIT debugging is enabled, any unhandled exception
will be sent to the JIT debugger registered on the computer
rather than be handled by this dialog box.


mikeshilov
#7 Posted : Thursday, July 07, 2011 1:50:24 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Birama, when do you get this? How to reproduce it?
Birama
#8 Posted : Thursday, July 07, 2011 3:57:47 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
I had take a print screen but I cannot post it.
So i have loaded a jobx file that I had created with the 5.7 version.
since I have installed the soft(v6) in a machine witch have not SQL SERVER installed,for testing I have loaded the jobx create before , i have checked
Quote:
schedule this job
;
Quote:
Advenced schedule
and after I have choosed
Quote:
lasy (168 H)
and have checked
Quote:
differential an log
after I have clicked the button
Quote:
show estimation plan
.
I can send image I'll do a print screen for all step.
mikeshilov
#9 Posted : Thursday, July 07, 2011 8:32:12 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
I've got it, it's certainly a bug, thank you. Please email us your name and email and we will send you a Prof license for v6 when we release it (in a week).
Guest
#10 Posted : Friday, July 08, 2011 9:01:22 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:

It seems this happens on your system only. We havn't received such reports from other users. So it's hard for us to reproduce and fix this problem.

Are you still able to test the application?


I think the system is cursed but the application runs fine till you try to hit save. It's curious because the system only has SQL 2008 R2 Standard and sqlbackupandftp installed.

I'll spin up a second VM and test there.
mikeshilov
#11 Posted : Friday, July 08, 2011 12:44:42 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Guest wrote:
I think the system is cursed but the application runs fine till you try to hit save. It's curious because the system only has SQL 2008 R2 Standard and sqlbackupandftp installed.


Yes it's strange. But from that crash report I can't say anything definite about the reason.
Guest
#12 Posted : Tuesday, July 12, 2011 5:04:39 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
Minor issue: I can't set the initial backup time when creating a backup using the Advanced SQLBackupAndFtp Service Scheduler. I have to switch back to using the Windows Scheduler (removing options for diff and log backups), set the time, go back in and reconfigure my advance backup settings again.
Guest
#13 Posted : Tuesday, July 12, 2011 5:36:13 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
Guest wrote:
Minor issue: I can't set the initial backup time when creating a backup using the Advanced SQLBackupAndFtp Service Scheduler. I have to switch back to using the Windows Scheduler (removing options for diff and log backups), set the time, go back in and reconfigure my advance backup settings again.


Edit from same user quoted:
It doesn't matter what time is selected in the "Start Full backup daily at" time spin edit on the main form. It will always default to the current time as the starting full backup time in the advanced scheduler. This means I have to change the time on the server itself if I want to schedule my backup rotation at a different time then the current server time, then change the time back. These times are also not reflected correctly in the "Jobs" area which just shows the time in the "Start Full backup daily at" time spin edit on the main form.

Dalen
mikeshilov
#14 Posted : Wednesday, July 13, 2011 4:37:22 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Dear Dalen,

We've already removed "Start Full backup daily at" to make it more simple. The final version will start full backup as soon as the job is scheduled. Sorry for not notifying about it and thank you for posting the feedback.

Mike
Guest
#15 Posted : Wednesday, July 13, 2011 11:31:31 AM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
Hi, i just found an bug!

do i still qualify for a free license? ;-)

MM
mikeshilov
#16 Posted : Thursday, July 14, 2011 2:13:50 AM Quote
Rank: Administration

Groups: Administrators

Joined: 8/12/2009
Posts: 271
Guest wrote:
Hi, i just found an bug!

do i still qualify for a free license? ;-)

MM


The beta testing is already closed, sorry ))
We are still interested to know about bugs though.
Guest
#17 Posted : Thursday, July 14, 2011 4:48:47 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
mikeshilov wrote:
The final version will start full backup as soon as the job is scheduled.

Would much prefer being able to set when the full backup is performed. Seems like an obvious feature to me. Most full backups are scheduled to be down outside of business hours, and having to change the server time temporarily to achieve this is not ideal. Will add a post to the feature request.

DaleN

Guest
#18 Posted : Thursday, July 14, 2011 5:15:34 PM Quote
Rank: Guest

Groups:

Joined: 8/10/2009
Posts: 725
[quote=mikeshilov]We've already removed "Start Full backup daily at" to make it more simple. quote]

I just downloaded version 6.0.10-free and I still see "Start Full backup daily at" on the front screen?

DaleN
ruslan
#19 Posted : Thursday, July 14, 2011 7:19:15 PM Quote
Rank: Administration

Groups: Administrators

Joined: 8/10/2009
Posts: 368
Dale,
there are some funny cases possible when user modifies the schedule of the job that is already running (like to make backups every 5 hours) - just look at "Show estimated plan" to clarify what is planned. If you are not happy - start (get back to if necessary) from the default scenario when you specify a starting time for full backup on the main form, then add advanced backup scenario from that starting point.
Quick Reply Show Quick Reply
New Topic Post Reply
Forum Jump  
You can post new topics in this forum.
You can reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You can create polls in this forum.
You can vote in polls in this forum.