Switching "warm" server to active
How do I change the status of the destination database from loading to being on-line and accessible? I understand that I can apply the last known good backup and change the option during a restore to â€œleave database operationalâ€. However, if this were a real-world scenario and the primary server suffered a major hardware failure, the last transaction log backup may have already been shipped to the backup server and would have been applied with the â€œnon-operationalâ€ option. In this case, with no more transaction log backups to apply, how do I make the database on the secondary server accessible?