All but 3 of our databases are replicated to a standby server. The remaining 3 databases were not designed with replication in mind and have been a thorn in my side for some time.
I have now been asked to use Simple Log Shipping to get those remaining databases relatively current on the standby server.
Our database script does a full backup once a day. Between full backups are differentials every 6 hours and transaction backups every 15 minutes.
I want to set up log shipping to occur every 15 minutes.
Right now, my biggest concern is how the backup script and the log shipping might interfere. If I keep the backup script running, will I lose transactions when the full backup occurs? If I drop these three databases from the full backup, wouldn't my transaction logs keep growing forever?
Any advice will be much appreciated.