robvil Posted November 4, 2009 Report Share Posted November 4, 2009 Hi, Running the newest version of multi serrver. I have a backupset containing MS SQL databases and I have set grooming to delete data older than 7 days. Looking at the backupset I can see there is very old sql databases that has been deleted from the sql server a long time ago. Does grooming not delete old removed databases? Regards Robert Quote Link to comment Share on other sites More sharing options...
Mayoff Posted November 4, 2009 Report Share Posted November 4, 2009 What type of SQL backups have you been doing? Incremental/Differentials? Quote Link to comment Share on other sites More sharing options...
robvil Posted November 4, 2009 Author Report Share Posted November 4, 2009 Full. Quote Link to comment Share on other sites More sharing options...
Mayoff Posted November 4, 2009 Report Share Posted November 4, 2009 Even though those databases have been deleted, they will not be removed from the backup. Retrospect keeps the last 7 backups of every source, even if they got deleted from the server 5 years ago. Quote Link to comment Share on other sites More sharing options...
Lennart_T Posted November 5, 2009 Report Share Posted November 5, 2009 I have set grooming to delete data older than 7 days. That's impossible. You can only tell Retrospect to keep the 7 latest backups, regardless of the number of days. Quote Link to comment Share on other sites More sharing options...
robvil Posted November 5, 2009 Author Report Share Posted November 5, 2009 Yes off cause. That was me not using my head... I manual forget the databases that had to be deleted from the backup set and ran a grooming afterwords. Regards Robert Quote Link to comment Share on other sites More sharing options...
Lennart_T Posted November 5, 2009 Report Share Posted November 5, 2009 Did your method solve your problem? How do you forget databases? I thought you could only forget snapshots. Quote Link to comment Share on other sites More sharing options...
robvil Posted November 5, 2009 Author Report Share Posted November 5, 2009 the database backup is a snapshot so I just deleted those snapshots I did not want to have in my backupset anymore. Robert Quote Link to comment Share on other sites More sharing options...
Richy_Boy Posted November 10, 2009 Report Share Posted November 10, 2009 We have a simular issue where an SQL database is deleted yet Retrospect still tries to back it up, throwing a 'database missing' error in the logs. Only clicking on the login button seems to kick off a SQL 2000 database scan again. Is this right? Seems odd it doesn't do a rescan each time it kicks off a backup of SQL. Rich Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.