|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Would it be possible to include command line option to allow creation of checksum information in full and differential backups?
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/10/2009
Posts: 368
|
Maybe. Since it is the first time we've been asked about it, I am not sure we have enough requests for it. Maybe a better option (that would envelop your request too) would be to create an interface to allow adding any custom arguments to BACKUP DATABASE statement. WDYT?
|
|
|
|
Rank: Newbie
Groups: Registered
Joined: 7/4/2011
Posts: 1
|
I've been a user of this software for almost 2 years. every morning i backup about 10 dB totaling about 35Gigs from 3 servers to an external Network storage Device. I have my system set to keep the last 7 days of backups but 10 days ago my SSD drive started acting up and corrupting data randomly.
Although my data was becoming more corrupt as the days passed, SQLbackupAndFTP continued to email me success information. when i need to restore the primary dB, all 7 backups had errors. i was forced to restore the earliest backup which had the least amount of errors and then "repair with data loss" and watch as SQL 2008 discarded an unknown amount of records.
if checksum was enabled the backups would have failed on the first day and i would have been notified.
please add this feature
Leon.
|
|
|
|
Rank: Administration
Groups: Administrators
Joined: 8/12/2009
Posts: 271
|
Well, indeed I think this feature is worthy of being added into the next release.
Leon, how do you think what is better: to add this option as a checkbox or add some text field to enable users to add various custom options to BACKUP DATABASE command?
Also wdyt about adding another option to verify the created backup using RESTORE VERIFYONLY command?
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Any news about those features? This would be a important function before making a decision which product to buy.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 179
|
We are going to add these features into the next release next week.
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 179
|
Hi, We have published SQLBackupAndFTP with this feature on download page. But among other changes we have migrated all of the settings from the registry to a file and have built a new service starter. This should resolve a number of issues related to access rights. If you would like to try it, you can download it using direct link: http://sqlbackupandftp.c...nload/SqlBakSetup650.exe
|
|
|
|
Rank: Guest
Groups:
Joined: 8/10/2009
Posts: 732
|
Hi,
Can anybody briefly explain the two options in "Sql Backup And FTP" ?
1: Add CHECKSUM option to BACKUP statement
2: Run RESTORE VERIFYONLY after backup
What is it they actually do - and in which cases are they useful?
Thanks!
|
|
|
|
Rank: Administration
Groups: Administrators, Registered
Joined: 12/1/2011
Posts: 179
|
|
|
|
|
|
