Activity overview
Latest activity by Giggles220
custom keys
It appears that you cannot create a custom key for comparison when comparing a backup to a database table. Is this by design? I use this option when comparing 2 tables and today I tried to use it w...
Errors in logs
I have noticed in our logs the following 2 errors:
2011-06-13 12:00:40,187 [SimpleThreadPoolWorker-21] ERROR RedGate.Response.Engine.Monitoring.Core.JobScheduler [(null)] - System.Collections.Gener...
SQL Prompt Hanging
Yesterday I updated my SQL Prompt from a version of 5. something to the most recent version 5.0.0.651. Now whenever suggestions pop up it freezes my whole Management studio for at least 20+ seconds...
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...
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...
Deleting files from Network Folder/copy location
I was really excited about this new feature but now I'm finding that it isn't working as advertised. I have my job set up to delete files older than 7 days in the original backup location and after...
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.
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.