Activity overview
Latest activity by pokhrea
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....
Question About Redgate Backup and Logshipping
Hi,
I am trying to use the logshipping feature within Redgate 4.5. Normally I do a full backup,hourly differential backup and 10 min logbackup to a backup server.
I want to keep this and also imple...
URGENT: SQL Backup Agent startup error
Hi,
My script from Redgate was not sending emails so I restarted the service and now getting all sorts of errors starting the service. My sql service is started using local system and agent and red...
COPYTO Syntax Query
Hi,
I have a script that backs up mutiple databases and i want to use the COPYTO option to backup a database on remote location but I want only 1 database to be copied over how can i do that?
Thanks
sqb2mtf errrors
Hi,
I copy the redgate backups to a different server without having redgate installed and want to restore the backup in that server. I am thinking of using the convert utility to convert into .BAK ...
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)
SQL server stopped unexpectedly
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...
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...
Syntax Error with SQL 2005 Sp1
Hi,
I upgraded my DB env to SQL 2005 SP1 with Redgate 4.5.
I have backup files in the foramt [Test][FULL][2006-07-17 220034].BAK.sqb ir [dbname][type][datetime]
I cannot restore this with the curre...