darkod Posted October 3, 2006 Report Share Posted October 3, 2006 Hi. We have Retrospect for Win 7.0 running, with Exchange and SQL agents. We have three different SQL servers (and three agent licenses of course). We have a dedicated backup server with the backup sets on its hard drives. This works fine. In order to have off-site copy we have recently started transfering the backup sets trough Retrospect on a tape drive connected to the backup server. So, the File backup sets get transfered to a Tape backup set. This works fine and reasonably fast for everything except one of the SQL servers. The transfer of that file backup set to the tape backup set can take hours, and sometimes even not finish in hours. I have tested even leaving it over night and on two ocassionas didn't finish after 20h so I stopped it. Retrospect is responding all the time, it's not stuck, I can easily stop the transfer of the backup set, but it can't seem to successfully finish. The other two SQL servers have only few databases each, and it's not a problem to transfer their backup set from file to tape. I don't know whether the db number makes a huge difference. The SQL that makes the problem has around 350 db I would say, and about 200-250 of them have changes on daily basis (so are included in our daily differential backup). The file backup set is not huge, at the end of the month (when we usually replace it with new backup set) it's barely 20GB. I can't see that being a problem to be transfered to tape. What am I doing wrong? Alternatively, any suggestion how to transfer file backup sets to tape except the Transfer Backup Set option in Retrospect? Why would a transfer of SQL backup from file set to tape set just stop? In the Executing window you can see the command being executed, however, the time counter which starts when the command starts just freezes at a certain time (usually at the beginning, after few minutes). Retrospect as a whole IS NOT frozen, it responds. It seems just the task out of whatever reason is not getting executed although it should. I don't know if i have explained everything in detail but please ask questions if you need some particular info. Thanks in advance. I would be really glad to sort it out, I am confused why I can't transfer that set. Cheers. Darko. Quote Link to comment Share on other sites More sharing options...
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.