I have 24/7 working production database ( SQL Server 2008) and taking full back up every day early morning 12:30 AM. It will be completed by 2:00 AM. Most of the tables are not having primary key and would like go for logshipping. Can I do it without taking any downtime with following.
- Restore the latest full backup to secondary server.
- Restore all log backups from 12:00 AM to till restore completion time.