Activity overview
Latest activity by jlynnmc10
What is 262144 in hex?
Thank you so much for your help!! My backups are now successful which helps me feel better why the Windows and Network teams continue to do their research. / comments
What is 262144 in hex?
Thank you so much for your help!! My backups are now successful which helps me feel better why the Windows and Network teams continue to do their research.
Can I set DISKRETRYCOUNT to 0 in the registry? I would like to turn this off for one of our servers with a large database as the retries are frequently not successful and cause the backup to take 3-7 hours longer to fail than if successful. Thanks. / comments
Can I set DISKRETRYCOUNT to 0 in the registry? I would like to turn this off for one of our servers with a large database as the retries are frequently not successful and cause the backup to take 3...
My backups write succesfully to the network share if I use native SQL backups but I want to use RedGate for the compression so I am still trying to trouble shoot this issue.
If I run the backup using the RedGate UI or run EXEC master..sqlbackup and specify a MAXDATABLOCK of 131072 my backups are successful and do not take too long so I would like to implement this setting for all backups on this one server.
I created a new registry key in the following location: HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\(LOCAL)
With these values:
Type = DWORD
Value name = MAXDATABLOCK
Value data = 131072
Hexadecimal
But when I run EXEC master..sqlbackup without specifying maxdatablock my backup still fails. Do I need to restart something or do something else for this registry setting to take effect? Shouldn't I be able to execu sqlbackup without specifying MAXDATABLOCK and it read the value from the registry?
Thanks. Jeralynn / comments
My backups write succesfully to the network share if I use native SQL backups but I want to use RedGate for the compression so I am still trying to trouble shoot this issue.
If I run the backup usi...
We are having severe performance issues with our network share which is being researched by the Network team but most of our large database retry 9 times and still never succeed which is only creating more contention on the network share. Is there a way to turn of the retries so I can do some testing? Thanks. / comments
We are having severe performance issues with our network share which is being researched by the Network team but most of our large database retry 9 times and still never succeed which is only creat...
Do re-attempts start over or continue where backup left off
I am getting the following errors when performing a full database backup. From these errors it appears that RedGate is re-attempting to back up the database. On a re-attempt does the write process ...
I also found that the following registry setting does not exist:
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\MAXDATABLOCK
If this setting does not exist then what is the default value? Can I add this setting and set it to 131072? / comments
I also found that the following registry setting does not exist:
HKEY_LOCAL_MACHINE\SOFTWARE\Red Gate\SQL Backup\BackupSettingsGlobal\<instance name>\MAXDATABLOCK
If this setting does not exist the...
The backup was successful when changing the MAXDATABLOCK value to 131072. Can I change this to be the default value for the server or can MAXDATABLOCK only be specified when executing the BACKUP command?
Thank you very much for your help. / comments
The backup was successful when changing the MAXDATABLOCK value to 131072. Can I change this to be the default value for the server or can MAXDATABLOCK only be specified when executing the BACKUP c...
Backup fails with "Insufficient system resources exist ...."
SQL Server 2005 SP3 Enterprise Edition
Windows Server 2003 Enterprise Edition
SQL Backup Version: 6.5.1.9
All backups (Full, Differential and Incremental) fail with the below errors. I am able to ...