pjscott13 Posted January 15, 2008 Report Share Posted January 15, 2008 Hi All, We are running Retrospect Multi Server Version 7.5.387 with Driver Update and Hot Fix Version 7.5.13.100 on a Windows 2003 Server. We have the SQL Server add-on and I have been backing up DB's with out any issues. I have noticed however that our Log files are becoming quite large. In investigating the issue it appears I may not be backing up our DB's correctly. I have not done a log backup, which explains the problem. I currently do a full backup once a week and differential backups for the rest of the week. I read a post on this forum suggesting that a log backup should be done immediately after the full backup. http://forums.dantz.com/ubbthreads/showflat.php/Cat/0/Number/48525/an/0/page/5#Post48525 My question is should I be running a log backup instead of the differential or should i be including a log backup with the differential or should i do a full backup immediately followed by the log backup and just continue differential backups for the rest of the week? What are others doing in this situation? Quote Link to comment Share on other sites More sharing options...
pjscott13 Posted January 15, 2008 Author Report Share Posted January 15, 2008 can anyone offer some advice? Quote Link to comment Share on other sites More sharing options...
pjscott13 Posted January 16, 2008 Author Report Share Posted January 16, 2008 Ok, so it seems I have to provide my own advice on this forum. Can someone please look over this schedule and tell me if it will work and not cause any problems... in particular when it comes to restoring: - Monday Morning Full SQL Backup (Recycle) - Weekdays Mon-Fri During Day Every 4 hours Log Backup (Normal) - Weekdays Mon-Fri Night Differential SQL Backup (Normal) Cycle repeats itself for the next week. What are some examples of schedules that you are doing? Quote Link to comment Share on other sites More sharing options...
emulator Posted August 14, 2008 Report Share Posted August 14, 2008 I think that this looks fine. You can check this thread out: http://forums.dantz.com/showtopic.php?tid/27109/ 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.