logshipping with multiple databases
I have to do log shipping for all the 100 database located on the production server. When i go and try to do it by wizard it will only let me do the log shipping set up for 1 database at a time and automatically 1 back up and 1 restore job is created by the wizard. In that scenario I will have to go through wizard 100 times and create 100 back up and restore jobs. Is there a way to do this easier and faster way in only 1 back up and restore agent job?