I need to set up log shipping for about 10 databases. Log backup would occur ever 4 hours and would need to restore automatically to the source server.
If anybody can help me with any kind of script which would work for this process, would be appreciated.
Thanks for your help.
Just follow the SSMS logshipping GUI for one db, script out the whole thing, and modify the scripts for the remaining 9 db's.
Sorry I meant 100 databases. This was there will be 3 job per database.
Is there way to get all dbs backuped in one job and another for restore. (don't really need the copy job)
Thanks