User profile for yrakesh

hmm... In that case we won't be able to effectively use the Licences which we had already bought. I was told that it is in development when I enquired with one of your developer. anyways thanks for clarification. Regds, Rakesh / comments

hmm... In that case we won't be able to effectively use the Licences which we had already bought. I was told that it is in development when I enquired with one of your developer. anyways thanks for...

0 votes

Thanks for your solutions Guys. We use Life-keeper Mirroring software to keep the data up-to date in secondary server. Unfortunately this server being in live production (billing engine runs in it) I can't take risk unless concrete solution is provided. I would really appreciate if you can give me step by step process to debug this issue which would be beneficial for both of us to drill down further. Best regards, Rakesh / comments

Thanks for your solutions Guys. We use Life-keeper Mirroring software to keep the data up-to date in secondary server. Unfortunately this server being in live production (billing engine runs in it)...

0 votes

Hi Brian, Thanks for the reply. I did upgraded to the latest version as well. Still the situation is same. Memory pool gradually increases until system just shuts down. Also we do use mirroring software to secondry server. will it have any affect? :roll: thanks, Rakesh / comments

Hi Brian, Thanks for the reply. I did upgraded to the latest version as well. Still the situation is same. Memory pool gradually increases until system just shuts down. Also we do use mirroring sof...

0 votes

Petty, Please find comments against u'r query - are you using Windows 2000 Advanced Server? => NO - what is the service pack level applied to the SQL Server 2000 instance? Microsoft SQL Server 2000 - 8.00.760 (Intel X86) Dec 17 2002 14:22:05 Copyright 1988-2003 Microsoft Corporation Standard Edition on Windows NT 5.0 (Build 2195: Service Pack 4) - is the 85 GB the size of the databases, or the size of the compressed backup files? => that is normal backup size not the complessed one. Please can u see why I'm facing this issue as I was running u'r s/w in Prodcution server!! Thanks. / comments

Petty, Please find comments against u'r query - are you using Windows 2000 Advanced Server? => NO - what is the service pack level applied to the SQL Server 2000 instance? Microsoft SQL Server 200...

0 votes

hi Pete, Can you please update? Let me know if u need more info.. thanks, / comments

hi Pete, Can you please update? Let me know if u need more info.. thanks,

0 votes

Hi Peter, sorry for delay.. Please find my comments.. Could you pls provide me the following information so that I may try to reproduce the error: > hardware - single-processo - amount of ram (2,095,508 KB RAM) > OS Microsoft Windows 2000 service Pack 4 - clustered - YEs > SQL Server SQL Server 2000 Ver 8.0 > SQL Backup details SQL Backup 3.2.0, (c) Red Gate Software Ltd 2004 - 2005 > backup details - number of backups ran before encountering error => for 5 days.. - backup script CREATE PROCEDURE spRG_ALL_DB_BACKUP AS set nocount on declare @datestamp varchar(30) declare @databasename varchar(200) declare @backuppath varchar(500) declare @filename varchar(500) declare @backupstring varchar(1000) declare @failcount int declare @failflag int declare @hresult int /* store OLE automation result */ declare @ole_FileSys int /* filesystemobject */ declare @ole_Folder int /* folder object */ declare @ole_Source varchar (255) declare @ole_Description varchar (255) declare @foldername varchar (255) create table #tmpsqberrors (failcode int) set @backuppath = 'D:\Backup\' declare dbs cursor for select NAME from sysdatabases where name not in ('tempdb') order by dbid open dbs fetch dbs into @databasename @fetch_status != -1 begin set @datestamp = left(replace(replace(replace(convert(varchar(30), getdate(), 120), '-', ''), ' ', ''), ':', ''), 12) --set @foldername=@backuppath + @databasename set @filename = @backuppath + '\' + @databasename + '_db_(full)_' + @datestamp + '.sqb' set @backupstring = '-SQL "BACKUP DATABASE TO DISK = ''' + @filename + ''' WITH NAME = ''Database (' + @databasename + ') Full'',MAILTO_ONERROR=''BBHATT@PRIMUSTEL.CO.UK'', ERASEFILES = 2, COMPRESSION = 2" -E' exec @failflag=master..sqlbackup @backupstring if @failflag=0 BEGIN insert into #tmpsqberrors (failcode) VALUES (1) END fetch dbs into @databasename END -- CLEANUP: close dbs deallocate dbs select @failflag=COUNT(*) FROM #tmpsqberrors if @failflag > 0 begin RAISERROR ('Backup failed to complete successfully for all databases.', 16, 1) end -- EXEC sp_OADestroy @ole_FileSys DROP TABLE #tmpsqberrors set nocount off RETURN 0 GO - frequency of backup schedule => Daily once - number of databases backed up per backup run => 37 - size of databases backed up => 85 GB (std SQL backup) > error information - how did you determine that it was a memory error? => System went down twice. Got to know the error from event monitor stating that Memory pool is full. - was the memory increase linked to the SQL Server process, or the SQL Backup service process? => AS soon as I disabled/ un-install red-gate SQL backup. Server is stable. - what are the errors recorded in the SQL Server log files - any errors recorded in the Windows event log Can't record any errors as I have to restart the system for first time. Second time when same issue occured, system autmatically shut down. I hope this info is suffice to investigate the prob / comments

Hi Peter, sorry for delay.. Please find my comments.. Could you pls provide me the following information so that I may try to reproduce the error: > hardware - single-processo - amount of ram (2,09...

0 votes

How can we help you today?

yrakesh

Comments