Switching "warm" server to active
summerm
Posts: 3
I’m currently testing SQL Backup Pro under the 14 day trial period on two SQL 2000 standard servers. I’ve been able to successfully use the log-shipping functionality. However, I have one problem I have been unable to resolve:
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?
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?
Get the latest news and training with the monthly Redgate Update
Comments
RESTORE DATABASE <database name> WITH RECOVERY
SQL Backup Consultant Developer
Associate, Yohz Software
Beyond compression - SQL Backup goodies under the hood, updated for version 8
Thanks for the reply.
Will this statement restore the entire database again, or will it just switch the mode from standby to live?
Jason