Comments
Sort by recent activity
Peter's subject is covered as redgate is being used to do the normal backup. How ever further doubts as to what Brian has suggested
I have 12AM full, 1 Hour Diff and 10 min log all round the clock. Now I am thinking of using logshipping wizard within Redgate for half hourly log structure to ship logs to a standby server starting from 12.30Am daily round the clock. If i set this up then there will be 2 jobs for tran log happening every 10 min and every half an hour both through Redgate so wondering if this is the way to implement this and checking to see if there will be any impact on the overall backup/restore sequence
Thanks / comments
Peter's subject is covered as redgate is being used to do the normal backup. How ever further doubts as to what Brian has suggested
I have 12AM full, 1 Hour Diff and 10 min log all round the clock....
No Errors on SQL error logs but windows event viewer system had error
under service control manager as
The MSSQL service terminated unexpectedly. This has done this 1(times) / comments
No Errors on SQL error logs but windows event viewer system had error
under service control manager as
The MSSQL service terminated unexpectedly. This has done this 1(times)
Hi,
I had an unusal issue with my production server. I have a daily job which backups full, hourly differential and 10 minute tran log. At Sunday 4AM normal diff and log comleted but Redgate had errors as below 6/08/2006 4:00:09 AM: SQL Backup process ended.
6/08/2006 4:02:44 AM: Warning 151: MAILTO error: Failed to send mail.
6/08/2006 4:02:44 AM: Warning 151: Unable to complete command, no storage available
6/08/2006 4:03:44 AM: Warning 151: MAILTO error: Failed to send mail.
6/08/2006 4:03:44 AM: Warning 151: Unable to complete command, no storage available
After that point the SQL services stopped unexpectedly. Iam using version 4.1 Redgate and this is the first time that this has happened. I also went through the previous log backups and it was taking about 3 minutes for a tran backup to complete.
Is this something that happens in redgate occasionally or can anyone tell me what might have caused it., any preventive mesures to overcome this as this is our production and we wont have choice but to turn this off if happens again.
Any help is highly regarded.
Anup / comments
Hi,
I had an unusal issue with my production server. I have a daily job which backups full, hourly differential and 10 minute tran log. At Sunday 4AM normal diff and log comleted but Redgate had er...
Thats works but it is really frustrating since we do a lot of things from the GUI which wont work either with this format. Since we are running trans log every 10 mins we need a good naming convention so that we can distinguish between various files in case of recovery. Please let me know what might be a workaround for this.
Thanks
Ap / comments
Thats works but it is really frustrating since we do a lot of things from the GUI which wont work either with this format. Since we are running trans log every 10 mins we need a good naming convent...
Yes thats returns a value. I copied the exe file and reran it and now it seems to be fixed. The other problem is now in a named instance on a server it shows that 4.5 is available but still is on the old version although the default instance is on 4.5.
I ran the exe manually and choose the named instance but it is still not upgrading. The other thing I noticed is that is is also stopping the service for this instance(sql backup agent) while it is upgrading.
Any Ideas why this might be happening.
Thanks / comments
Yes thats returns a value. I copied the exe file and reran it and now it seems to be fixed. The other problem is now in a named instance on a server it shows that 4.5 is available but still is on t...