Activity overview
Latest activity by cameron.gibbs
MOVETO error - file exists
I have a problem with the log shipping - it seems to work most of the time but we often have the situation where a log is restored and then coped to the processed log file location but not deleted ...
Log ship to different server version
Can I setup log shipping to ship from a SQL 2000 source server to a SQL 2005 destination server ?
Cheers,
Cameron
Thanks Eddie,
I'll give that a go and see what happens.
Can you perhaps explain to me why the SQL Backup GUI does not add this option in ? Having a setting in the GUI for removing the old files that doesn't actually remove the files seems a bit pointless.
Cameron / comments
Thanks Eddie,
I'll give that a go and see what happens.
Can you perhaps explain to me why the SQL Backup GUI does not add this option in ? Having a setting in the GUI for removing the old files th...
Processed log files not being deleted
When log shipping was setup, I set the option to delete processed logship files after 7 days (168 hours), but the files are not being deleted as they should be - the script for the job is below.
An...
Sorry Matthew - I should have posted my update...
The issue was that the server that was taking ages to complete was doing the nightly backups as well as 15 minute backups for DR etc. The backup history was never being truncated so it was taking an age to update it.
Once I truncated the backup history and am keeping that under control, the backup completes in a few minutes as expected.
BTW - it was SQL Server job history that was reporting the 48 minute job time.
Thanks,
CJ / comments
Sorry Matthew - I should have posted my update...
The issue was that the server that was taking ages to complete was doing the nightly backups as well as 15 minute backups for DR etc. The backup h...
Yeah I have VERIFY on for all backups - this server/set of databases is the only one that is behaving like that. / comments
Yeah I have VERIFY on for all backups - this server/set of databases is the only one that is behaving like that.
Job ending long time after backup completed
I have several jobs on several servers backing up databases from 10MB to 4.5GB, and they all finish in times close to what standard SQL Server backup jobs do, except...
on 1 server the SQL backup t...
Thanks Matthew - I did find closing/opening the GUI worked. / comments
Thanks Matthew - I did find closing/opening the GUI worked.
oh well that sucks !!!!
thanks for confirming my fears
think i'll look at database mirroring when we move to 2005 later this year / comments
oh well that sucks !!!!
thanks for confirming my fears
think i'll look at database mirroring when we move to 2005 later this year
um 5.3 is the latest version...I downloaded it yesterday / comments
um 5.3 is the latest version...I downloaded it yesterday