Jump to content

Mass SQL db backup and restore


danno74

Recommended Posts

We are trying to utilize Retrospect to backup SQL dbs on our main server, and then restore them to another SQL server, so that our month end data is available the entire month.

 

I did another full set of backups for all live offices again late yesterday afternoon. When I tried to run the restore script, it didn't work, as the "source" backup was no longer on the tape (the original backup from yesterday morning). I don't get it - what good is scripting if you have to recreate the script everytime you do a backup? Especially when you have to do each restore separately? That doesn't make sense, there has to be something we're missing. There are many companies that do SQL backups on multiple databases every day, sometimes multiple times per day.

 

Any ideas?

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...