I've got a production db that has users in it from 6:00 AM to 11:00 PM and runs batch processes from 11:30 PM to 1:00 AM. After that it does maintenance jobs to be RTG at 6:00 AM the next morning.
I want to set up log shipping. I've got another server ready to go, but I'm not clear on just what the steps are when the db is in production like that.
Does the target server need to have RedGate Backup Pro installed?
When should I take the backup that goes on the second server to be the basis for the log shipping?
How do I insure that the shipping starts up smoothly if the database is in use?
Am I making this harder than I need to?