Yes, I know this is how SQL Server Log Shipping works. You set the option when you set up the log shipping using the GUI. However, as I stated, I am using Red Gate SQL Backup to do my log shipping and, while it offers an option to place a database in STANDBY, it does not specify how to choose one of the options nor which one is the default. This is what I need to know.