Activity overview
Latest activity by lculley2011
Checksum resources
For SQL Backup Pro 7.0, how does the checksum check affect resources on the file system in terms of CPU, memory and I/O? Is it worse or better than verifying the header information?
SQL Backup pro 6.0 support for 7.0
I have sql backup pro 6.0 and would like to test the automated restore functionality on my restore server. Does 7.0 support restoring red gate backup pro 6.0 backups?
That did work but when I had run the backup previously using the following, the data was not saved in backupset. I just tried again using the syntax below and did see data saved in backupset. A bit confused now.
DECLARE @exitcode int
DECLARE @sqlerrorcode int
EXECUTE master..sqlbackup '-SQL "BACKUP DATABASES [model] TO DISK = ''\\MIAUTP01\sqlbackup\MIASQP01\<DATABASE>\<AUTO>.sqb'' WITH ERASEFILES = 2, MAILTO_ONERRORONLY = ''group@company.com'', DISKRETRYINTERVAL = 30, DISKRETRYCOUNT = 10, THREADCOUNT = 3, VERIFY"', @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
That did work but when I had run the backup previously using the following, the data was not saved in backupset. I just tried again using the syntax below and did see data saved in backupset. A b...
msdb.dbo.backupset does not contain Red Gate backup metadata
For certain databases I backed up using red gate backup outside of a sql job and for the rest I have them in a regularly scheduled job. For those backed up inside of a job, I get a record in msdb....
That is what it is--it is a user database that is configured for replication. I just expected to see the distributor. Please consider this ticket as closed. / comments
That is what it is--it is a user database that is configured for replication. I just expected to see the distributor. Please consider this ticket as closed.
SQL Backup 6.5 shows user database as replication databases
I have sql backup 6.5.1.9 installed and in the GUI for creating a new backup job for some reason user databases are showing up as replication databases in the list. I am able to select all of the ...