Comments
Sort by recent activity
Thanks for your replies. I know that Red Gate developers and support personnel are very responsive to user needs. Thanks for the help. I may use SQL Backup 4 client when I'm in a hurry. I'll give it a try.
Thanks again. / comments
Thanks for your replies. I know that Red Gate developers and support personnel are very responsive to user needs. Thanks for the help. I may use SQL Backup 4 client when I'm in a hurry. I'll give i...
Peter,
I downloaded and installed the debug version of xp_sqlbackup.dll. The client still displays the same error message.
The debug DLL has a version of 5.0.0.964.
The 5.1 DLL has a version of 5.1.0.2781.
Is the debug version correct. Did I download the right file?
Terry / comments
Peter,
I downloaded and installed the debug version of xp_sqlbackup.dll. The client still displays the same error message.
The debug DLL has a version of 5.0.0.964.
The 5.1 DLL has a version of 5.1...
This is the complete SQL batch that executes the SQBUtility.
__________________________
declare @P1 int
set @P1=NULL
declare @P2 nvarchar(4000)
set @P2=NULL
declare @P3 int
set @P3=NULL exec master..sqbutility @Parameter1 = 1080, @Parameter2 = @P1 output, @Parameter3 = @P2 output, @Parameter4 = @P3 output
select @P1, @P2, @P3
__________________________ / comments
This is the complete SQL batch that executes the SQBUtility.
__________________________
declare @P1 int
set @P1=NULL
declare @P2 nvarchar(4000)
set @P2=NULL
declare @P3 int
set @P3=NULLexec master....
Peter,
The service is started and has been running since installation. Regular backups occur. The only problem is getting the client to work on this server.
Terry / comments
Peter,
The service is started and has been running since installation. Regular backups occur. The only problem is getting the client to work on this server.
Terry
The Free Blk count is 210. / comments
The Free Blk count is 210.
When do you anticipate release of version 4? / comments
When do you anticipate release of version 4?
Yes. SQLBackup is working now because I restarted the SQL Server service. Had to get the nightly backups done. I'll run memstat next time backups begin to fail and post the output.
Thanks for your help. / comments
Yes. SQLBackup is working now because I restarted the SQL Server service. Had to get the nightly backups done. I'll run memstat next time backups begin to fail and post the output.
Thanks for your ...
SQLBackup has run without any problem, today. Memstat shows that the maximum free space is now 75,522,048. That is less than half of 169,521,152 that was free last night. How much free space is needed for SQLBackup? Is the server approaching the threshold?
Thanks,
Terry / comments
SQLBackup has run without any problem, today. Memstat shows that the maximum free space is now 75,522,048. That is less than half of 169,521,152 that was free last night. How much free space is nee...
Here is the MEMSTAT output. I hope you will explain it as there is no documentation with the tool. memstat - Yohz Software (c) 2005 - 2006
Type Maximum Minimum Average Blk count Total
---------------- ----------- ----------- ----------- ----------- -----------
Commit 4096 879820800 1714066 1048 1796341760
Reserve 8192 1032192 359424 152 54632448
Free 4096 169521152 1976292 150 296443904
Private 4096 879820800 2632996 683 1798336512
Mapped 4096 1060864 148650 48 7135232
Image 4096 7569408 97020 469 45502464
/ comments
Here is the MEMSTAT output. I hope you will explain it as there is no documentation with the tool.memstat - Yohz Software (c) 2005 - 2006
Type Maximum Minimum Average ...
We perform multiple backups within the backup job. The first time the error occurs, it may happen on the first or any subsequent backup. After that it usually fails on the first backup attempted.
Here are the VDI contents for the last error that occurrred.
2006/01/16 18:46:30 pid(3208) tid(5496)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at ServerBufferAreaManager::Allocate: Map buffers Status Code: 8, x8
Explanation: Not enough storage is available to process this command.
2006/01/16 18:46:30 pid(3208) tid(5496)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked
2006/01/16 18:46:30 pid(2860) tid(4624)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at CVD::GetCommand: AbortDetected
2006/01/16 18:46:30 pid(3208) tid(3728)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked
2006/01/16 18:46:30 pid(3208) tid(3728)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at SVDS::CloseDevice: Abort detected
2006/01/16 18:46:30 pid(3208) tid(3728)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked
2006/01/16 18:46:30 pid(2860) tid(4624)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked
2006/01/16 18:46:30 pid(3208) tid(5496)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked
2006/01/16 18:46:30 pid(2860) tid(4368)
Error on Global\SQLBACKUP_{8123B2FB-D86A-46DE-801D-BF12C8A5DAE1}
Error at TriggerAbort: invoked / comments
We perform multiple backups within the backup job. The first time the error occurs, it may happen on the first or any subsequent backup. After that it usually fails on the first backup attempted.
H...