Comments
Sort by recent activity
it was 2009 / comments
it was 2009
Thanks very much! / comments
Thanks very much!
Hi Richard, thanks, that works! The OLE DB Error is gone. Thanks again and best Regards, Volker Bachmann
/ comments
Hi Richard,thanks, that works!The OLE DB Error is gone.Thanks again and best Regards,Volker Bachmann
Hi Richard, sorry, you lost me at SQL CE and sql103-ams. What does that mean? The server components are all Version 9.2.2.303 an my gui also. [image] Where should I look now? Regards, Volker / comments
Hi Richard,sorry, you lost me at SQL CE and sql103-ams. What does that mean?The server components are all Version 9.2.2.303 an my gui also.Where should I look now?Regards,Volker
Hello,
as far as I read the release notes of Version 5.4 the parameter FILEOPTIONS and ERASEFILES_REMOTE didn't make it into this version of the GUI. Am I right?
When will they go into?
Regards,
Volker / comments
Hello,
as far as I read the release notes of Version 5.4 the parameter FILEOPTIONS and ERASEFILES_REMOTE didn't make it into this version of the GUI. Am I right?
When will they go into?
Regards,
Vo...
I got it.
The option must be included without quotation marks
Wrong
ERASEFILES_REMOTE = '24h'
Right
ERASEFILES_REMOTE = 24h
There is a typo in the help at this point.
Thanks.
Regards,
Volker / comments
I got it.
The option must be included without quotation marks
Wrong
ERASEFILES_REMOTE = '24h'
Right
ERASEFILES_REMOTE = 24h
There is a typo in the help at this point.
Thanks.
Regards,
Volker
Thanks,
why does the implementation of such options last so long?
Anyway:
I tried to use the option erasefiles_remote this night for the first time with the version 5.3.0.178.
But the backup fails when I add
erasefiles_remote = '20h'
EXECUTE master..sqlbackup N'-SQL "BACKUP DATABASES [< multiple datbases> ] TO DISK = ''E:\SQLBackup\<AUTO>.sqb'' WITH COMPRESSION = 3, COPYTO = ''\\<server>\SQLBackup'', ERASEFILES = 1, FILEOPTIONS = 1, ERASEFILES_REMOTE = ''20h'', MAILTO = ''<email>'', THREADCOUNT = 15, VERIFY"', @exitcode OUT, @sqlerrorcode OUT
with this error:
Syntax error: '20h' after '='
Raiseerror:
SQL Backup failed with exit code: 850 SQL error code: 0
What's wrong?
The "<>" values are filled correctly as the backup with erasefiles_remote=1 runs normally.
May I use erasefiles_remote= 0 to delete every old backup on the remote server? That would fix my problem here.
Thanks.
Regards,
Volker / comments
Thanks,
why does the implementation of such options last so long?
Anyway:
I tried to use the option erasefiles_remote this night for the first time with the version 5.3.0.178.
But the backup fails ...
It works - thanks very much.
But after editing this nothing can by changed with the GUI - so if I want to add another Database to backup with this Job first the parameter has to be deleted and afterwords added again.
Please change this behavior.
Regards,
Volker Bachmann / comments
It works - thanks very much.
But after editing this nothing can by changed with the GUI - so if I want to add another Database to backup with this Job first the parameter has to be deleted and afte...