danno74 Posted November 2, 2006 Report Share Posted November 2, 2006 We run two jobs at the beginning of each month, one to backup all SQL tables on this one server (X), and then we run a restore of this tape to another server (Y). The script for the end of month (EOM) backup run on X was lost because we have to remove the license and add it back in order to see new databases (very, very inconvenient btw). Since our tech recreated the job, the completion time has gone from 45min to an hr to 3 hrs. This is not due to space because the new SQL db is small since it is a new office. Verification is off. The time it takes to restore to Y is the same. Anyone know of any other settings I can look at? The server gets rebooted every week, it's not a server/memory issue, and the server is only running Retrospect. Please help, I'm getting heat because our EOM process needs to be as short as possible. Quote Link to comment Share on other sites More sharing options...
AmyJ Posted November 2, 2006 Report Share Posted November 2, 2006 Quote: The script for the end of month (EOM) backup run on X was lost because we have to remove the license and add it back in order to see new databases (very, very inconvenient btw). I'm not sure about the speed, but why do you have to relicense to see new databases? If SQL is running on the client go to Configure > Clients > Properties > Volumes and select the new databases. They will then be available for backup. Quote Link to comment Share on other sites More sharing options...
danno74 Posted November 3, 2006 Author Report Share Posted November 3, 2006 Thanks for the tip, Retro Support couldn't give me that one, should send along to their reps tp make sure they take note. Quote Link to comment Share on other sites More sharing options...
danno74 Posted December 1, 2006 Author Report Share Posted December 1, 2006 Just a note, this works much faster when I backup the SQL dbs to the local HD, then restore from there. Got it back down to an hour, much better. Wonder, if it was a tape issue. Quote Link to comment Share on other sites More sharing options...
AmyJ Posted December 1, 2006 Report Share Posted December 1, 2006 Thanks for the update... You're right. Sounds like the drive was the bottleneck. 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.