Comments
Sort by recent activity
If you review the SQL Backup log files for when you expect files to be deleted, are there any error or warning messages?
How long ago did you upgrade to version 5.4? / comments
If you review the SQL Backup log files for when you expect files to be deleted, are there any error or warning messages?
How long ago did you upgrade to version 5.4?
Yes, it will delete any files in both folders which are older than the hours/days specified and are of the same type/database/instance/server as the one being backed up. / comments
Yes, it will delete any files in both folders which are older than the hours/days specified and are of the same type/database/instance/server as the one being backed up.
Hi,
Unfortunately after editing your script to include these parameters you can no longer edit it in the SQL Backup GUI.
What version of the SQL Backup Server Components are you running?
Could you please use Help>Check for updates in the SQL Backup GUI to upgrade to 5.4 and then upgrade the Server Components?
Thanks, / comments
Hi,
Unfortunately after editing your script to include these parameters you can no longer edit it in the SQL Backup GUI.
What version of the SQL Backup Server Components are you running?
Could you ...
Your command will delete the primary backup file and this can be done through the SQL Backup GUI on either the Backup or Scheduled Backup wizard. The option is :
Delete existing backup files in this folder for the selected databases.
If you want to also delete files in a secondary location (Copy backup to network) you need to add FILEOPTIONS = 1 to your command if running it manually or edit the SQL Server Agent job in SSMS/EM to include FILEOPTIONS = 1 in the job step.
Running manually would become : EXEC master..sqlbackup '-sql "BACKUP DATABASE AdventureWorks TO DISK = [g:\backups\<AUTO>] WITH ERASEFILES = 2h, FILEOPTIONS = 1" '
I hope this helps. / comments
Your command will delete the primary backup file and this can be done through the SQL Backup GUI on either the Backup or Scheduled Backup wizard. The option is :
Delete existing backup files in th...
If it is a scheduled job, you will need to open SSMS/EM, expand SQL Server Agent>Jobs and right click on the job you wish to edit, choosing properties.
On this screen click on Steps, make sure the step is highlighted and choose Edit.
You should now see the backup command that the job will run, here you can edit it.
If you are just using the Backup Wizard, you need to copy the the script from the script tab, paste it into SSMS/QA and then edit it to include FILEOPTIONS = 1 before executing it. / comments
If it is a scheduled job, you will need to open SSMS/EM, expand SQL Server Agent>Jobs and right click on the job you wish to edit, choosing properties.
On this screen click on Steps, make sure the ...
Hi Illuminations2k,
You can achieve this by having WITH ERASEFILES = x, FILEOPTIONS = 1 in your job which runs. This will then erase both local and remote files according to the same retention period.
Replace x with the number of days you wish to keep the files for. If it is only hours use xh.
I hope this helps. / comments
Hi Illuminations2k,
You can achieve this by having WITH ERASEFILES = x, FILEOPTIONS = 1 in your job which runs. This will then erase both local and remote files according to the same retention per...
Hi,
I am a little confused by your line :
The error message and the application starts up cleanly each time now - tested 3 times.
Are you still encountering the error message or is the GUI starting cleanly?
Thanks, / comments
Hi,
I am a little confused by your line :
The error message and the application starts up cleanly each time now - tested 3 times.
Are you still encountering the error message or is the GUI start...
Hi fatherjack,
Could you please try the following :
Close the SQL backup GUI. Kill the process if necessary.
Navigate to %:\Documents and Settings\<username>\Local Settings\Application Data\Red Gate\SQL Backup\Server Data
Delete the contents.
Open the SQL Backup GUI.
Use the SQL Backup GUI as normal and see if you still encounter the problem when closing.
Thanks, / comments
Hi fatherjack,
Could you please try the following :
Close the SQL backup GUI. Kill the process if necessary.
Navigate to %:\Documents and Settings\<username>\Local Settings\Application Data\Red Gat...
Hi larbs,
You have a few options to achieve this :
Convert one of your weekly Full Backups to mtf format and restore it using SSMS/QA.
To convert the file you can use sqb2mtf (found in your SQL Backup Installation folder with instructions in the help file) or use the GUI version available from : http://labs.red-gate.com/index.php/SQL_ ... _Converter
Alternatively you could take a Native Full Backup, SQL Backup differential and transaction log backups will run from the Native Backup but you should keep it at least until the next weekly full SQL Backup has completed successfully.
The 3rd option would be to use the COPY ONLY option as per you post update.
I hope this helps. / comments
Hi larbs,
You have a few options to achieve this :
Convert one of your weekly Full Backups to mtf format and restore it using SSMS/QA.
To convert the file you can use sqb2mtf (found in your SQL Bac...
Hi Olivierp,
You can download just the SQL Backup installer from Here
Thanks, / comments
Hi Olivierp,
You can download just the SQL Backup installer from Here
Thanks,