Comments
Sort by recent activity
I have seen this effect too sometimes- usualy selecting "line level timings" helps here. / comments
I have seen this effect too sometimes- usualy selecting "line level timings" helps here.
If this doens't work, I find this solves 80% of all such problems:
Run the Red Gate SQL Backup agent as Local System. Job done. / comments
If this doens't work, I find this solves 80% of all such problems:
Run the Red Gate SQL Backup agent as Local System. Job done.
Hi there - I thinik this is the same query that came through our support channel. The resolution was:
After many controls on SQL Server 2005 we see that there was a limit about rows written by process history: maximum row number was 1000.
We modify this value setting it to 10000 and all it's OK. / comments
Hi there - I thinik this is the same query that came through our support channel. The resolution was:
After many controls on SQL Server 2005 we see that there was a limit about rows written by proc...
I'm not the expert here but I have an idea of the situation and I think I can help. Firstly, in your second post you've got exactly the right idea.
However, the problems you raise in your third post are not to do with dependencies - as Data Compare ignores them (FK, constraints, ref. integrity are disabled before and then re-enabled after the script is run)- but I think the failures are simply that the database is being updated at the same time. In which case the only recommendation is to run the script at a quieter time. Data Compare is good but not quite that good, yet [image] / comments
I'm not the expert here but I have an idea of the situation and I think I can help. Firstly, in your second post you've got exactly the right idea.
However, the problems you raise in your third pos...
Can you please turn on logging for the service by doing the following :
Open regedit and navigate to the following registry key :
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent(_InstanceName)
Modify the ImagePath value by appending -sqbdebug to the end of the string.
Now please try restarting the SQL Backup Agent.
A log file should be created in the Server Components Installation directory (%:\Program Files\Red Gate\SQL Backup\<instance name> by default).
Could you please send me any log files contained there (support@red-gate.com , subject: F0024635)?
If no log is created, please ensure the SQL Backup Agent Service has permissions to write to the folder where it is located. / comments
Can you please turn on logging for the service by doing the following :
Open regedit and navigate to the following registry key :
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\SQLBackupAgent...
To reset the status, run these to delete the backed-up copies:
run this first:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist'
see what the stauts of the jobs is (we think its going to be 'A') then run:
EXEC MASTER..sqbdata 'delete from backupfiles_copylist where status = 'A''
(if necessary, change 'A' to the correct status) / comments
To reset the status, run these to delete the backed-up copies:
run this first:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist'
see what the stauts of the jobs is (we think its going to be...
Also, you can use this to make sure there no copy errors:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist_log' / comments
Also, you can use this to make sure there no copy errors:
EXEC MASTER..sqbdata 'select * from backupfiles_copylist_log'
We'd better check out the logs which are, by default, here:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance>
Also- could you send the script used that causes the problem? / comments
We'd better check out the logs which are, by default, here:
C:\Documents and Settings\All Users\Application Data\Red Gate\SQL Backup\Log\<instance>
Also- could you send the script used that causes ...
This sounds like its a problem with restarting the IIS service which is needing an account with admin rights. Is it true that gpierson is not an administrator of this computer? Are you able to run ANTS as a user with admin rights? / comments
This sounds like its a problem with restarting the IIS service which is needing an account with admin rights. Is it true that gpierson is not an administrator of this computer? Are you able to run ...
I've been working with ANTS and MOSS for a while now and have managed to overcome pretty much all profiling issues.
We have a build of ANTS that overcomes several permission issues, please try this (the features here will make it into a GA release soon): ftp://support.red-gate.com/Patches/ANTS ... AnyCpu.exe
If you're still getting no joy, try my small app that sets up an environment variable that ANTS needs: ftp://support.red-gate.com/Patches/ANTS ... _0.0.2.exe
If still no joy, I have to ask: are you 100% sure you are using the right log on (test with a different browser- I recommend chrome - it actually remembers what you typed in unlike IE, you can use chrome with ANTS- as soon as it starts profiling you can use any old browser). / comments
I've been working with ANTS and MOSS for a while now and have managed to overcome pretty much all profiling issues.
We have a build of ANTS that overcomes several permission issues, please try this...