I am new to sql server & i need some help regarding log shipping. I have one centralized database server & 5 locations across india each location database is primary database for that perticuler location. On each location we have installed sql server 2008 r2 database. I want to use centralized server for restoring all 5 locations database and generate reports which will show the history of restored database.each location database file size 65 mb as of now.
Can any one please guide me in understanding the concept of log shipping and can it suffice my need.