Comments
Sort by recent activity
Helen
The job runs every night so I'd expect it to do deletes every night.
Here is the code in the job. I created the job using the GUI and did not modify it outside the GUI at all. DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES EXCLUDE [master] TO DISK = ''e:\backups\BIPRODUCTION\<database>\<type>\<AUTO>.sqb'' WITH ERASEFILES = 7, ERASEFILES_REMOTE = 4, MAILTO_ONERROR = ''_sqlpsqi@dfa.state.ny.us'', PASSWORD = ''<ENCRYPTEDPASSWORD>xxxxxx</ENCRYPTEDPASSWORD>'', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, COMPRESSION = 3, COPYTO = ''\\mscotda0a1bg\sqlback\mscotda0a1azbiproduction\<type>\<database>'', KEYSIZE = 256, THREADCOUNT = 3, DIFFERENTIAL"', @exitcode OUT, @sqlerrorcode OUT
IF (@exitcode >= 500) OR (@sqlerrorcode <> 0)
BEGIN
RAISERROR ('SQL Backup failed with exit code: %d SQL error code: %d', 16, 1, @exitcode, @sqlerrorcode)
END
/ comments
Helen
The job runs every night so I'd expect it to do deletes every night.
Here is the code in the job. I created the job using the GUI and did not modify it outside the GUI at all.DECLARE @exitcod...
our password has not changed so all the files should have the same password. This folder only contains differential backups per the script. I just looked at the folders and now it appears that files are being deleted. Is it possible that SQL Backup 6 will not remove sql backup 5 files? / comments
our password has not changed so all the files should have the same password. This folder only contains differential backups per the script. I just looked at the folders and now it appears that file...
moving another window over the client does not seem to have any affect at all. / comments
moving another window over the client does not seem to have any affect at all.
ok found the cache, cleared it reopened the GUI nothing there. Found the log and emailed that off. / comments
ok found the cache, cleared it reopened the GUI nothing there. Found the log and emailed that off.
when I look here:
C:\Documents and Settings\admxm6229\Application Data\Red Gate\SQL Backup
I have no folders just a servers.dat file. / comments
when I look here:
C:\Documents and Settings\admxm6229\Application Data\Red Gate\SQL Backup
I have no folders just a servers.dat file.
I could not seem to find the local cache directory, or else there were no files. I made the registry edit but again couldn't find the log file either. / comments
I could not seem to find the local cache directory, or else there were no files. I made the registry edit but again couldn't find the log file either.
I agree with Dan. I'd love to let the copy to a newtork drive be queued so my backups complete first. To me having my initial backup is more important that having the backup copied out to my DR site. If 1 database gets hung up because my DR site is unavailable it will hold up all the other databases backups. I'd love to see this included or as an option for the user to decide if they want fulls and diffs queued as well. / comments
I agree with Dan. I'd love to let the copy to a newtork drive be queued so my backups complete first. To me having my initial backup is more important that having the backup copied out to my DR sit...
I've been manually removing our windows users every time I do a compare ever since I started using the product over 3 years ago. I'd love a way to filter out windows users. / comments
I've been manually removing our windows users every time I do a compare ever since I started using the product over 3 years ago. I'd love a way to filter out windows users.
I must have missed this post when it was originally posted. This is also a HUGE problem for us. We too have links to the documentation and I just had a manager come to me and ask for the documentation to be updated since it hadn't been done since March. Is it possible to get the older version that would not use the sub folders? or is there a time frame for a fix for this? / comments
I must have missed this post when it was originally posted. This is also a HUGE problem for us. We too have links to the documentation and I just had a manager come to me and ask for the documentat...
I would not want it to change to automatically use all objects regardless of their checkbox state. I'd rather see an option to include all or just selected. Alot of times I only generate the report for selected objects but I do understand that others may want everything.
BTW, I like the change that all objects are not automatically selected after the compare. / comments
I would not want it to change to automatically use all objects regardless of their checkbox state. I'd rather see an option to include all or just selected. Alot of times I only generate the report...