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. 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. 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. 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. 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. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.