Comments
Sort by recent activity
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...
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.
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...
Thanks Matthew - I did find closing/opening the GUI worked. / comments
Thanks Matthew - I did find closing/opening the GUI worked.
um 5.3 is the latest version...I downloaded it yesterday / comments
um 5.3 is the latest version...I downloaded it yesterday
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